Stroed Procedure in SQL SErver 2005
-
Hello Every1
Please excuses me if this sounds very stupid.
I wish to know if there is some object where the "text" of the Stored Procedure are stored.
If yes, please let me know the how can I query.
Ankit
-
In 2004 you query sys.sql_modules
David
-
Cool. What would you use in 2005?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Oops I meant 2005 just my typing again
David
-
Forgive us our typos as we forgive those who typo against us... unless you just ran a restore on the production server...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply