开发者

need to recreate sp_send_dbmail in msdb system procedure folder

开发者 https://www.devze.com 2023-02-10 17:47 出处:网络
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

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

精彩评论

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