Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
RE: Using system catalog views to retrieve OBJECT_DEFINITION for sawesome, tx
"thomarse" wrote:
> If 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
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
