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 |
|
azamsharp
Posting Yak Master
201 Posts |
 Posted - 2005-12-29 : 02:20:04
|
| How can I view my temp stored procedure? I wrote my procedure in Query analyzer and then I cleared the screen and now I want to see the defination of my temporary stored procedure. I went to see in the tempdb but there are no temporary stored procedures thereMohammad Azam www.azamsharp.net |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-29 : 03:30:32
|
| sp_helptext 'ProcedureName'MadhivananFailing to plan is Planning to fail |
 |
|
|
azamsharp
Posting Yak Master
201 Posts |
Posted - 2005-12-29 : 17:14:39
|
| Thanks :DMohammad Azam www.azamsharp.net |
|
|
|
|
|
|
How to view my temp stored procedure