dbTalk Databases Forums  

Shortcut For QA

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Shortcut For QA in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Neil
 
Posts: n/a

Default Shortcut For QA - 10-27-2007 , 11:26 PM






When I open QA on my development machine, I almost always go to the same db.
Is it possible to create a shortcut for QA which tells it to go to that db,
and also provides the login and password? Thanks,

Neil



Reply With Quote
  #2  
Old   
kb
 
Posts: n/a

Default Re: Shortcut For QA - 10-28-2007 , 01:21 AM






Quote:
When I open QA on my development machine, I almost always go to the same
db.
Is it possible to create a shortcut for QA which tells it to go to that
db,
and also provides the login and password? Thanks,
"%ProgramFiles%\Microsoft SQL
Server\80\Tools\Binn\ISQLW.EXE" -SYourServerName -dDatabase -ULogin -PPassword


--
Tom
http://kbupdate.info/




Reply With Quote
  #3  
Old   
kb
 
Posts: n/a

Default Re: Shortcut For QA - 10-28-2007 , 01:25 AM



Quote:
When I open QA on my development machine, I almost always go to the same
db. Is it possible to create a shortcut for QA which tells it to go to
that db, and also provides the login and password? Thanks.

"%ProgramFiles%\Microsoft SQL
Server\80\Tools\Binn\ISQLW.EXE" -SYourServerName -dDatabase -ULogin -PPassword
Usage: ISQLW.EXE
[-S <[server]>]
[-d <database>]
[-E] trusted connection
[-U <[login id]>]
[-P <[password]>]
[-f <file list to load>]
[-i <input filename>
-o <output filename>]
[-1] Single instance mode
[-T <template directory>]
[-D <script directory>]
[-C <configuration file>]
[-F <U | A | O>] file format (Unicode | ANSI | OEM)


--
Tom
http://kbupdate.info/




Reply With Quote
  #4  
Old   
Neil
 
Posts: n/a

Default Re: Shortcut For QA - 10-28-2007 , 09:43 AM



Thanks!

"kb" <admin (AT) kbupdate (DOT) info> wrote

Quote:
When I open QA on my development machine, I almost always go to the same
db.
Is it possible to create a shortcut for QA which tells it to go to that
db,
and also provides the login and password? Thanks,

"%ProgramFiles%\Microsoft SQL
Server\80\Tools\Binn\ISQLW.EXE" -SYourServerName -dDatabase -ULogin -PPassword


--
Tom
http://kbupdate.info/




Reply With Quote
  #5  
Old   
Jim McLeod
 
Posts: n/a

Default Re: Shortcut For QA - 11-06-2007 , 06:14 AM



Quote:
When I open QA on my development machine, I almost always go to the
same db. Is it possible to create a shortcut for QA which tells it to
go to that db, and also provides the login and password? Thanks,
Neil
Hi Neil,

You can create a shortcut to isqlw.exe (Query Analyzer) like:
isqlw.exe -S myserver -d mydatabase -U username -P password

For more details, check out
<http://msdn2.microsoft.com/en-us/library/aa214005>(SQL.80).aspx

Cheers,
Jim

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.