http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/reflect-a-tsql-routine.aspxEver want to see the text of a stored procedure, function, or trigger -- or manipulate the text in some way? sp_helptext works, sort of. But I really don't like the way it handles large procedures (> 4000 characters). They seem to end up with someenCommunityServer 2.1 SP2 (Build: 61129.1)