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 |
|
filf
Yak Posting Veteran
67 Posts |
 Posted - 2001-07-16 : 06:58:42
|
| I have a number of stored procs on a remote server and I have a web based query analyzer thru which I can run TSQL. My prob is I want to double check some sp's to see that they are the same as my local setup, I could just alter them all to what I have locally, but I just want to confirm each sp's definition rather than do this. Just for my personal peace of mind how would I do this with sql bearing in mind I have the names of all the sp's.As for the current cursor discussion I am a convert - I just modified one script that was using cursors [60 - lines] got it down to 30 lines using a pure SQL solution. Admittedly my knowledge of SQL is improving all the time so this has helped, but I honestly thought that what I was trying to do could only be done with cursors - discussions like this are good because in my case it promoted self investigation and enhancement. |
|
|
|
|
|
Can I select a sp's definition thru a Q-Analyzer