Re: Generate SQL Script for Stored Procedures
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/25/04
- Next message: Sue Hoegemeier: "Re: Copying Linked Server Config from one server to another"
- Previous message: jzhu: "Re: Pesky Home Page"
- In reply to: Barb: "Generate SQL Script for Stored Procedures"
- Next in thread: Barb: "Re: Generate SQL Script for Stored Procedures"
- Reply: Barb: "Re: Generate SQL Script for Stored Procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 25 Mar 2004 07:32:42 -0700
As Hari pointed out, system stored procedures won't show up
in the Generate SQL Script dialog from Enterprise Manager.
If you are trying to script out system stored procedures,
you can script these individually using the object browser
in Query Analyzer. If you right click on the stored
procedure in the object browser, you get scripting options.
You can script the stored procedure to a file by selecting
Script Object to File as Create.
-Sue
On Wed, 24 Mar 2004 16:50:22 -0800, "Barb"
<anonymous@discussions.microsoft.com> wrote:
>I want to script some stored procedures before I drop
>them. When I right click on the master database, and
>select generate sql script, I see 2 objects for the master
>database, the helpbox procedures.
>
>If I right click on the stored procedure itself, the
>generate sql script is greyed out.
>
>would appreciate help on this. Thanks.
- Next message: Sue Hoegemeier: "Re: Copying Linked Server Config from one server to another"
- Previous message: jzhu: "Re: Pesky Home Page"
- In reply to: Barb: "Generate SQL Script for Stored Procedures"
- Next in thread: Barb: "Re: Generate SQL Script for Stored Procedures"
- Reply: Barb: "Re: Generate SQL Script for Stored Procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
