Re: Backing Up Stored Procedures

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/23/04 

Date: Mon, 22 Mar 2004 20:19:42 -0600

Right click on the db in Enterprise Manager and choose All Tasks - Generate
SQL Script. Here you can script them all or just selected ones. 

--
Andrew J. Kelly  SQL MVP
"barb" <anonymous@discussions.microsoft.com> wrote in message
news:1198d01c4106d$70603750$a401280a@phx.gbl...
> We do not need some of the default stored procedures.
> Security docs say to drop. I want to backup before I drop
> in case I need to add back at later date. How do I "script
> out" the stored procedures? Thank you.
>
>
>
>
>
> >-----Original Message-----
> >Backup the database which contains the stored procedures.
> >You backup everything in the database when you do a
> backup.
> >Not sure if you mean you want the stored procedures
> separate
> >from everything else or not but you could script out the
> >stored procedures if you need something along those lines.
> >
> >-Sue
> >
> >On Mon, 22 Mar 2004 10:34:36 -0800, "barb"
> ><anonymous@discussions.microsoft.com> wrote:
> >
> >>How do I Backup stored procedures?
> >
> >.
> >

Relevant Pages

  • Re: convert to stored procedure + NDS
    ... Is there a clever way or an existing script I ... can use to find/replace multiple DDL statements in each sql script ... statements into stored procedures so I don't have to manually do so. ...
    (comp.databases.oracle.tools)
  • Re: convert to stored procedure + NDS
    ... Is there a clever way or an existing script I ... can use to find/replace multiple DDL statements in each sql script ... Puget Sound Oracle Users Groupwww.psoug.org ... statements into stored procedures so I don't have to manually do so. ...
    (comp.databases.oracle.tools)
  • Re: Generate SQL Script for Stored Procedures
    ... >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 ...
    (microsoft.public.sqlserver.security)
  • Re: Generate SQL Script for Stored Procedures
    ... system stored procedures won't show up ... in the Generate SQL Script dialog from Enterprise Manager. ... procedure in the object browser, ...
    (microsoft.public.sqlserver.security)
  • RE: Backup
    ... You want to choose the "backup database" option. ... "Generate an sql script" ... It just creates a script that you can run to ...
    (microsoft.public.sqlserver.programming)