Nakul Vachhrajani (10/6/2010)
Also, please avoid using syscomments - this will be deprecated in a future version of SQL Server. Use sys.sql_modules instead.
You can also use the really nice OBJECT_DEFINITION() function. Depending on your query it may be easier.
Jerry