formatted output

[Subhas]

Hi,
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.......... ..

Regards

Subhas

[Erland Sommarskog]

Re: formatted output

Subhas (dba_sybase2003 @yahoo.com) writes:[color=blue]
> 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.......... ..[/color]

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, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp