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