Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to print stored procedures?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00667914
Message ID:
00667939
Vues:
19
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform