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.


Jason

Jason
I'm afraid you cannot in SQL Server 2000, unless open a new connection .




"Jason Huang" < JasonHuang8888@hotma
il.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@hotma
il.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
>