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 - 2003-03-30 : 18:47:27
|
| If I use windows search to locate stored procedures with a keyword, double-clicking the filename will launch a new copy of QA requiring login, even if I have a copy of QA running..Any way around this?Sam |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-03-31 : 01:57:37
|
Hi Sam:When you say double clicking on a stored procedure, I suppose you mean the .sql file that contains the script for the SP. In that case, my pc seems to give a slightly different result. If I already have a copy of QA running, and I double-click on a .sql file (and QA must be registered as the default application for query files), it opens a new window within the same instance, asking me to login. I found this logical, since QA wouldn't know which server and database this script is supposed to run on.The only way *I* know around it is to simply drag-and-drop the file onto a running instance of QA. That way it just pops up a new window with the script inside it, on the currently running connection.*Phew* all this chatter on the assumption that its a .sql file you are talking about!!  OS |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-31 : 03:03:10
|
| Create a .bat file with the following command"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe" -Scqsdev -Uuser -Pcpwd -f%1Or wherever isqlw.exe is on your systemuse -E for iontegrated security.Make this the prog to open your .sql file with and it should open them in a logged in qa window.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-31 : 03:08:52
|
| There seems to be a bit of confusion on the actual nature of this question.I think the gist of it is actually how to avoid multiple instances of QA when double clicking on an associated file.Damian |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-31 : 03:23:17
|
| Or just avoid the login but...There must be an easier way than the way I posted as I've seen it without the dos window - never thought to ask.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Launch QA from Windows Explorer