Re: Generate SQL Script for Stored Procedures

From: Barb (anonymous_at_discussions.microsoft.com)
Date: 03/25/04


Date: Thu, 25 Mar 2004 07:12:58 -0800

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...
>> 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.
>
>
>.
>



Relevant Pages

  • Re: Generate SQL Script for Stored Procedures
    ... Master database contains only the system stored procedures and those will ... not be shown in "Generate SQL Script". ... Please try with your user database ...
    (microsoft.public.sqlserver.security)
  • Re: Get All User Permissions
    ... Look for INFORMATION_SCHEMA views in master database. ... can be found in books online. ... using following tables(unless somebody somewhere has that script already): ... > pass in a SQL Server account name and will then report back on all ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE - Master database
    ... I am just testing at the moment, only installed mSDE a few days agao. ... Is there no script somewhere that I can delete and recreate. ... >> What is supposed to be in te master database, and how can I fix it. ...
    (microsoft.public.sqlserver.msde)
  • Re: MBS Great Plains
    ... Which database do I run this script against? ... I did try running it against the master database and when I look at my tables they still do not have the NOT FOR REPLICATION property. ... I ran RECONFIGURE. ...
    (microsoft.public.sqlserver.replication)
  • Re: Copy Tables
    ... Keep in mind that you can issue a WHERE clause to filter the results to include the rows that you want. ... you can automate script generation using the SQLDMO API. ... >> backed up to an sql script, then i want to restore the database from the ... >> other server, then i want to reload the sql script with the veiws in it, how ...
    (microsoft.public.sqlserver.setup)