Save password
-
Hi,
How can i save my password in the query analyser. When i start the query analyser it always asks me to login.
Regards
-
use windows authentication. Open QA from EM against a registerd server.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
Yep i know. And what if i don't want to use the win. auth?
-
ISQLW accepts command line parameters. start>>Run isqlw /? will give you the list; then simply create a shortcut like isqlw.exe -s[localhost] -dmaster -Usa -Ppassword
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Which Query Analyzer version ur using, In Management Studio 2005 query analyzer has an option to save login id and password when selecting SQK authentication but in SQL Server 2000 Query Analyzer, you have to supply loginID and password.
-
That is what is was looking for. Thanks mate!
-
since he posted to this forum, I kind of assumed he was talking about SQL 2000; I've got an instance of 2005 as well, but I haven't used it enought to be aware of some of the differences; I'm just using it to test compatibility for applicaitons and procs/functions.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply