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?

Is it on a shared hosting plan ? or do you control the SQL server ?

I'm going to assume its on shared hosting and as such you really should ask hosting365 I'll assume you're not allowed access to it. Not to mention depending on how it works it could generate a lot of emails and while not positive I assume they've got a policy about sending a certain amount of emails within X amount of time

__________________
Forbairt Media | Web Design & Development Galway / Dublin, Ireland - coming soon ... ( vague but descriptive isn't it )
Recent Work: Safari Club African Safari Holidays - South Africa Safaris
Other Stuff: FluffyLinkulator Rapid Inclusion Service Tools

Yeah, it's shared hosting, I'll ask them can I use it, I presume I can't so I'll have to write my own sproc I spose.
Every one I've seen uses some kind of sproc that is internal to SQL Server which requires admin privileges to use them.
.

Maybe a stupid question, but why not do it in php/asp rather that stored procedure.

__________________

Not stupid at all, I want to use a stored procedure as all the other db stuff is done using sprocs so I want to have consistency. Also, I want to learn about it as the purpose of the site is to help me get employment as a web developer.
I want to do something a bit different and difficult so I can show I know stuff and can use my initiative.

Have you gotten onto your hosting provider about it yet?? They should be able to tell you staright out!

__________________
Irish Gaming Network | Stolen Car Listings

Yeah, I'm gonna have to ask them as I've googled out all possibilities.
I saw a sproc that can do it but it uses a sproc called sp_OACreate.
I got back this error:
"EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'." as I don't have permission to use it.

I asked them and they said to re-name the procedure from "msdb.dbo.sp_send_dbmail" to "'mydatabasename'.dbo.sp_send_dbmail".
I did that but of course the compiler said it couldn't find that procedure.
So I created it from the "msdb.dbo.sp_send_dbmail" I have on my own local machine but it gave me a load of errors.
I'll have to do it in C#, I need it up and running soon.