Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-09-14 : 23:43:29
|
| Hello im trying to see the script in one of the stored procedure in SQL 2005 but it retuns blank. im using this syntax sp_helptext <stored proc name>. and set the results to text. any advice please |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-09-15 : 00:45:34
|
| Do you have permission? Or may be the SP is encrypted.Did you try this option: Right click on SP >> script SP as >> create to >> New query editor window hey |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 00:59:12
|
| what do you mean by blank? did you get some error/warining message?also try this:-select text from syscomments where text like '%yourprocedure%' |
|
|
|
|
|
|
Showing stored procedure script