TechQA.

need to recreate sp_send_dbmail in msdb system procedure folder

146 views Asked by mson At 16 February 2011 at 19:11

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?

There are 1 answers

gbn

gbn On 16 February 2011 at 19:18 BEST ANSWER

The undocumented stored proc sp_MS_marksystemobject still works on SQL Server 2008 according to the recent Google links I found on it.