Changing user in sql query analyzer

Hi,
In SQL Server 2000's SQL Query Analyzer, how do I change the login account?
I mean if I am using UsrA in the Analyzer, how do I switch to UserB by SQL
command?
Thanks for help.
JasonJason
I'm afraid you cannot in SQL Server 2000, unless open a new connection .
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:%23tox$%23FFHHA.3288@.TK2MSFTNGP05.phx.gbl...
> Hi,
> In SQL Server 2000's SQL Query Analyzer, how do I change the login
> account?
> I mean if I am using UsrA in the Analyzer, how do I switch to UserB by SQL
> command?
> Thanks for help.
>
> Jason
>|||> I mean if I am using UsrA in the Analyzer, how do I switch to UserB by SQL
command?
In 2000, you only have the SETUSER command, but it changes the user context,
not the login context.
In 2005, you have the EXECUTE AS command, and you decide whether to change u
ser or login context.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:%23tox$%23FFHHA.3288@.TK2MSFTNGP05.phx.gbl...
> Hi,
> In SQL Server 2000's SQL Query Analyzer, how do I change the login account
?
> I mean if I am using UsrA in the Analyzer, how do I switch to UserB by SQL
command?
> Thanks for help.
>
> Jason
>