469,090 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

formatted output

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
Jul 20 '05 #1
1 2576
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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Craig Thomson | last post: by
8 posts views Thread by Matthew Thorley | last post: by
2 posts views Thread by Steven T. Hatton | last post: by
3 posts views Thread by Craig Petrie | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.