Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to print stored procedures?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00667914
Message ID:
00667939
Views:
20
>Periodically I would like to print all stored procedures.
>Is there a SQL utility that would allow you to do this?
>Where are stored procedures stored (what table)?
>Can it be pulled into fox so I can print them?

I don't know of any clear-cut way of doing it but you may be able to do it like so:
- Run the following query in the desired database to obtain the list of stored procedures:
Select name From sysobjects Where type='P'
- For each sp name in the result set, run this other one:
sp_helptext 'sp_name_here'
Print the resulting query directly or make a big table or text file to print all at one time.

The other option would be to use SQL-DMO to script each stored procedure to a file for printing. HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform