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 |
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
 Posted - 2004-09-21 : 10:42:24
|
| Anyone know if there is a command that I can use to view a stored procedure in Query Analyer?I usually open enterprize manager and copy it over to QA to edit it. There has got to be a better way.Thanks,Doug |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-09-21 : 10:45:28
|
| Either use sp_Helptext or the object browser to script the sp to a new window.Raymond |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-21 : 10:46:44
|
right click on the sproc in qa, choose script object to new window as -> alter. voilaGo with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
Command to bring up SP in Analyzer?