开发者

need to recreate sp_send_dbmail in msdb system procedure folder

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜