Sunday, February 19, 2012

2005 Management Studio - New Query

Assume we're using SQL Server authentication. In 2000's Query Analyzer,
once you had logged in, you could open up several new query windows without
having to repeatedly log in each time. Logging in the first time is
important to validate that you are who you say you are. However, in 2005's
Management Studio, every time I open up a new query window I'm prompted for
my credentials. Is there a way to avoid this? I can easily have 10+
windows open at a time.
Thanks in advance.
Mark
Problem solved. The SQL Editor toolbar has an option titled "New Query with
Current Connection" that has the exact behavior I am looking for.
Mark
"Mark" <mark@.nojunkmail.com> wrote in message
news:es9LYcOyFHA.2880@.TK2MSFTNGP12.phx.gbl...
> Assume we're using SQL Server authentication. In 2000's Query Analyzer,
> once you had logged in, you could open up several new query windows
> without having to repeatedly log in each time. Logging in the first time
> is important to validate that you are who you say you are. However, in
> 2005's Management Studio, every time I open up a new query window I'm
> prompted for my credentials. Is there a way to avoid this? I can easily
> have 10+ windows open at a time.
> Thanks in advance.
> Mark
>

No comments:

Post a Comment