Re: How to extract texts of all stored procedure

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/12/04 

Date: Wed, 11 Aug 2004 21:59:57 -0400

Right click on the database in Enterprise Manager and select "All Tasks" and
then "Generate SQL Script". This will allow you to generate scripts for all
types of objects including sp's. 

-- 
Andrew J. Kelly  SQL MVP
"Jack" <Jack@discussions.microsoft.com> wrote in message
news:C3386DFA-1174-4946-ABED-F95A6401FC83@microsoft.com...
> I need to extract the texts of all procedures of a database. What would be
> the easiest way to do that? Thanks in advance. Regards.

Relevant Pages

  • Re: Missing file from MS.NET Compact Framework Kick Start
    ... let apologize for the missing files in our samples. ... The readme.txt file from Chp 9 in describes how to set up the test database ... is a sql script file that will set up the Quotes database on the server. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: newable copy question
    ... The easiest way is to right click on the database in Enterprise Manager and ... choose "All Tasks" - "Generate SQL Script". ... and I have to copy the test database from the ...
    (microsoft.public.sqlserver.server)
  • sql trouble
    ... database from one table to the other using an sql script, ... having trouble dong that. ... The existing database has the following: ... ELEMENT_SHAPE_ID long, foreign key ...
    (comp.lang.java.databases)
  • How can I check..
    ... The easiest way is to do into Enterprise Manager, ... by selecting the database, all tasks, generate sql script, ... >I have one database file in separate filegroup. ...
    (microsoft.public.sqlserver.server)
  • Re: How can I make a primary key in my SQL database?
    ... > I normally use code like this when connecting to my database... ... How can I define a Primary Key? ... script is to use the Generate SQL Script function in Enterprise Manager. ...
    (microsoft.public.inetserver.asp.db)