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 |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2004-02-24 : 10:57:23
|
| in sql query analyzer, is there a way to display the script that is used in a certain sp? all i'm doing is putting the name of the sp in sql query analyzer and running it. now i want to see the sp script w/o opening enterprise manager. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-24 : 11:01:46
|
| QA Menu itemTools>ObjectBrowser>Show/HideOr just hit F8Brett8-) |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-02-24 : 14:23:53
|
| Why wouldn't you just use sp_helptext 'ProcName'?Or highlight the sp and hit Alt+F1?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-24 : 14:30:06
|
| I find the object browser to be easier. You just right click on it and hit edit. It'll automatically put ALTER instead of CREATE. It also puts the SET commands that were used on CREATE. To each his own though.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-02-24 : 14:44:17
|
| Object Browser. You're so new school. (grin)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-24 : 14:50:25
|
| I just adapt. I've been working on SQL Server since 4.2 (very little though, mostly 6.5 and newer). If I find that the tool can make my life easier, I use it.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-02-24 : 14:58:39
|
| I've been using it since 4.2 also. I was just kidding with you. I like the object browser. There's so many ways to do things in 2000. I find myself using all of them at times. Just depends on what I'm doing at any given time.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-24 : 15:45:36
|
| Hell, I didn't even knew ezisted until Tara told me sometime last year(still don't use it)Brett8-) |
|
|
|
|
|
|
query analyzer question