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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-07-18 : 12:41:01
|
| I'm using Windows Explorer to Search for stored procs containing a table. Works great, less filling.Although I keep QA open, if I double-click on a found SP, a new invocation of QA is opened and requires that I type in the password.Is there a way to optimize this so I don't need to login to QA every time I open an SP?Sam |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-18 : 13:21:10
|
| You could change your default for the extensions to a batch file that calls isqlw with the username and password.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-18 : 17:03:30
|
| If you drag the file from Windows Explorer onto an already-open window in Query Analyser, then QA will open a new window [for the file from Windows Explorer] using the connection properies of the QA Window you dragged it on to.Its a heck of a sight easier to do, that to explain! You can even drag multiple files onto a QA Window in this way, and it will open child windows for each file. No UserID/Password required!Kristen |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-07-18 : 18:27:34
|
| Thanks... |
|
|
|
|
|
|
Find and Edit