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:
00667936
Vues:
21
>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?

Take a look at http://www.sqlmag.com/Forums/messageview.cfm?catid=22&threadid=2469. The idea is to script SP and print result.

You can also try
USE myDB
Select name, colid, "text" FROM syscomments sc
	JOIN (Select id, name From sysobjects Where type='P') sop
	ON sc.id = sop.id
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform