We have a SQL Server 2008 system.
Somehow the sp_send_dbmail sproc got deleted from msdb.
When I recreate the sproc, it does not get put in the system folder and gets put in the general sproc folder of msdb.
开发者_如何学编程Anyone know how to move the sproc or create it in the correct directory?
The undocumented stored proc sp_MS_marksystemobject
still works on SQL Server 2008 according to the recent Google links I found on it.
精彩评论