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

> 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/

> > 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/

Thanks!

"kb" <admin [at] kbupdate.info> wrote in message
news:fg19oh$23rp$1 [at] ns.felk.cvut.cz...
>> 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/
>

> 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