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.
|