If you want to see the raw SQL behind your stored proc (like you can
in SQL Server Management Studio) then use:
EXEC sp_HelpText 'your procedure name'
Found in http://stackoverflow.com/questions/467482/how-do-i-programmatically-retrieve-sql-server-stored-procedure-source-that-is-ide
No comments:
Post a Comment