RE: Lost Stored Procedures
From: Jonas Larsen (JonasLarsen_at_discussions.microsoft.com)
Date: 12/07/04
- Next message: Le Coq De Mort: "Esql/C calling stored procedure with output parameters"
- Previous message: JL: "Re: SQL Backup"
- In reply to: Jonas Larsen: "Lost Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 6 Dec 2004 16:55:05 -0800
Ok what have I done. Take the routine_definition from another servers master
and recreated them on the problem server via scripting.
Regards
Jonas
"Jonas Larsen" wrote:
> 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
- Next message: Le Coq De Mort: "Esql/C calling stored procedure with output parameters"
- Previous message: JL: "Re: SQL Backup"
- In reply to: Jonas Larsen: "Lost Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
