Lost Stored Procedures

From: Jonas Larsen (JonasLarsen_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 15:33:02 -0800

Hi guys

I have a problem. somehow all the stored procedures in the Master Database
have been deleted and the backup is not working. And I have checked
SysObjects they are gone.

Does anyone know how I can get the SP's back? (I have other SQL Servers
running).

Thanks.

Regards
Jonas

Relevant Pages

  • Re: Moving a database
    ... using 'Restore backup' found on .msc applet ?? ... (i see on Tibor's site a tip - Restore all databases from a number of backup ... a backup is essentially a binary copy of the database. ... >> If the stored procedures were in the original database they will be ...
    (microsoft.public.sqlserver.tools)
  • Re: Export Stored Procedures
    ... Stored procedures will be stored in the sysobjects table. ... Query-analyzer will show all stored procedures related to your database. ... DTS will make it possible to import the file into sysobjects. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 Backup of Stored Procedures
    ... stored procedures are saved as you can easily see by restoring a backup ... that are saved in the master database; these are not saved if you are ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Backing Up Stored Procedures
    ... SQL Script. ... Here you can script them all or just selected ones. ... > We do not need some of the default stored procedures. ... >>Backup the database which contains the stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Execute Persmission denied on object sp_OACreate
    ... I have a user who has execute permissions on a store procedure in a database ... which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)