Home > Archive > MS SQL Server > November 2006 > RE: Using system catalog views to retrieve OBJECT_DEFINITION for s









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author RE: Using system catalog views to retrieve OBJECT_DEFINITION for s
Tadwick

2006-11-30, 7:14 pm

awesome, 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.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com