Subhas (db************@yahoo.com) writes:
Is there a way to get stored procedure texts out in a formatted way
like defncopy in Sybase????? The way they print it out really
sucks............
There is no command-line utility, but there are scripting facilities
both in Query Analyzer and Enterprise Manager.
In QA click F8 to get an Object Brower. Right-click a procedure and you
find the scripting option. In EM, right-click a database and pick
All Tasks and then Generate SQL Scripts.
--
Erland Sommarskog, SQL Server MVP,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp