Posted by Jeff Kish on 05/17/07 12:21

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

>Jeff Kish (jeff.kish@mro.com) writes:
>> 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.
>
>If you found your procedure in master, it was because you added it there,
>probably by mistake.
>
>
>> So.. my question.. is it normal for procedures in other databases to be
>> reflected also in the master database,
>
>Well, you are not the first to make the mistake. But that's not the same
>thing as normal.
>
>> and then how can I restore / recover the master database if necessary.
>
>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!
Thanks much.
I keep getting my priorities switched around... its hard to keep up on all the
docs, but I keep peeking in there.
Jeff Kish

[Back to original message]