Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesIf I want to document my sprocs using system catalog views the OBJECT_DEFINITION (object_id) retrieves raw text. Is there any way of retrieving my code while retaining the formatting (ie indents). Tx, Tad
Post Follow-up to this messageIf you're using SQL Server 2005 you can use sys.sql_modules
e.g.
select definition from sys.sql_modules
where object_id = object_id('your_proc
_name')
This retains the correct formatting.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread