0

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?

Improve this question
1
  • I have to do this for one of our servers, did you have any luck recreating it? I am thinking I'm just going to script the procedure from a working instance.
    – Connor Williams
    Commented Jul 13, 2016 at 11:43

1 Answer 1

Reset to default
1

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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.