Posted by Ed Murphy on 05/16/07 15:13

Jeff Kish wrote:

> 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,

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.

> and then how can I restore / recover the master database if necessary.
>
> I am using sql server 2005 on XP pro.

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

• Next in forum: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities
• Prev in forum: Re: create constraint error
• Thread view: Re: how to if needed recover from mistake

[Reply to this message]