View Single Post

  #1 (permalink)  
Old 17-12-2007, 10:37 PM
fonzi fonzi is offline
Coder
 
Join Date: Sep 2007
Posts: 33
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
fonzi will become famous soon enough
Default SQL Server question

This is a database question, nothing to do with coding really so I hope it's OK to ask it here.
I am using Microsoft SQL Server 2005 as my database for my website (hosted by hosting365).
I want users to be able to send emails from a contact form on one page and there is a stored procedure called msdb.dbo.sp_send_dbmail @recipients in SQL Server that allows a user to do so just by calling it.
(It's under System Databases-msdb-Programmability-Stored Procedures-System Stored Procedures in my SQL Server Management Studio Express).
It's not there in the hosting365 server when I log in to it in Management Studio Express and when I tried to use it it said 'Server user 'myusername' is not a valid user in database 'msdb'.
Does this mean it is there but I can't use it? Can I ask hosting365 to give me permission to use it? Or is it not actually there at all?

Last edited by fonzi; 17-12-2007 at 10:41 PM.
Reply With Quote