0

Hi.....

i create a new user in mssql... user is --- kumar

now i login to mssql by using the above user...

now i login to mssql with another console by using administrator account.....

now i try to delete the account(@ present in administrator account) -- kumar
....

then the kumar account not deleted....and shows the following error message...

do not delete the account currently logged in

...........
please solve my problem...

Regards,
deepu

2
Contributors
1
Reply
2
Views
11 Years
Discussion Span
Last Post by itsdavetime
0

You can't drop a user if they are currently logged in. Do an sp_who to find the SPID's the user is logged in with, and kill those spid's. Then drop the user.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.