Generate SQL Script for Stored Procedures

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.Hi,
Master database contains only the system stored procedures and those will
not be shown in "Generate SQL Script". Please try with your user database
and try generating the script.
Thanks
Hari
MCDBA
"Barb" <anonymous@.discussions.microsoft.com> wrote in message
news:12f2e01c41203$270271d0$a401280a@.phx
.gbl...
> 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.|||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.|||Thank You.

>--Original Message--
>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:
>
master
>.
>|||Thank You.

>--Original Message--
>Hi,
>Master database contains only the system stored
procedures and those will
>not be shown in "Generate SQL Script". Please try with
your user database
>and try generating the script.
>Thanks
>Hari
>MCDBA
>"Barb" <anonymous@.discussions.microsoft.com> wrote in
message
> news:12f2e01c41203$270271d0$a401280a@.phx
.gbl...
master
>
>.
>