Posted by Erland Sommarskog on 10/02/44 11:53

byrocat (bdealhoy@sympatico.ca) writes:
> A system stored procedure got accidentally deleted, and all backups are
> since the stored procedure was deleted (wonderful!)
>
> Can the SQL for the stored procedure be extracted from another server
> and loaded as opposed to removing everything and then rebuilding the
> server?

Even better, you can retrieve it from one of the files INSTALL directory for
your SQL Server instance. Make sure you run exec sp_MS_marksystemobject on
the procedure when you have created it, or else it may not work like
system procedure usually do.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL 2005 - SQLDMO - Adding Logins/ Users
• Prev in forum: Re: Replace Access with a .NET front end and SQL Backend solution.
• Thread view: Re: Recreating/reloading system stored procedures

[Reply to this message]