Hi.
I deleted a stored procedure (one I had written) out of the master database. I
thought I had accidentally put it there, then I got to thinking.. what if it
is normally reflected there, and maybe I should not of deleted it.

So.. my question.. is it normal for procedures in other databases to be
reflected also in the master database, and then how can I restore / recover
the master database if necessary.

I am using sql server 2005 on XP pro.

thanks for the advice
Jeff Kish

Jeff Kish wrote:

Not in my experience. I haven't used SQL Server 2005 yet, but this
doesn't seem like something that would have changed there. I would
guess that someone just forgot to pick the right the database before
running a CREATE PROCEDURE command.

Googling ("SQL Server 2005" "restore master") turns up
http://msdn2.microsoft.com/en-us/library/ms190190.aspx

Jeff Kish (jeff.kish (AT) mro (DOT) com) writes:
If you found your procedure in master, it was because you added it there,
probably by mistake.


Well, you are not the first to make the mistake. But that's not the same
thing as normal.

I recommend that you read in Books Online if you are interested in
this exercise. That's at least where I would look, if I would run into
the situation that I would need to restore a master database. I don't
do it often enough to know the procedures by heart!



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Wed, 16 May 2007 22:46:15 +0000 (UTC), Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

I keep getting my priorities switched around... its hard to keep up on all the
docs, but I keep peeking in there.
Jeff Kish