I have been scouring the web for hours with no success.
I am looking for a way to fetch a function's script/code content. I have a way of doing this with stored procedures (see below), I also need to do this with functions.
SELECT [sp].[name], [sc].[text], [sc].[ctext]
FROM SYSCOMMENTS AS [sc]
INNER JOIN SYS.OBJECTS AS [sp] ON [sc].[id] = [sp].[object_id]
WHERE [sp].[type] = 'p'
Any suggestions would be greatly appreciated.
Thanks in advance for all the trouble.
View Complete Post