How to switch to different user in SQL server 2005?

0 ⤊

How to switch to different user in SQL server 2005?

Hi,
I would like to switch to some other user in between the session. What is the command for the same in SQL Server 2005?

2006-12-21 15:49:50 · 1 answers · asked by Radha 1 in Computers & Internet ➔ Programming & Design

1 answers

The SQL user you are logged in as is set at the connection level. In order to change the user, you must disconnect and reconnect to the server using the new credentials.

2006-12-21 17:51:05 · answer #1 · answered by Rex M 6 · 0⤊ 0⤋