Could not drop login as the user is currently logged in.

[Modica82]

I am trying to drop a login and then reinstate it, as a script but i keep getting this error:

Could not drop login as the user is currently logged in.

my scripts is:

EXEC sp_droplogin 'CTS'
EXEC sp_addlogin 'CTS', 'password'
exec sp_addrolemember 'db_owner', 'CTS'

Any ideas??

Thanks,

Rob

---------------------------------------

http://www.thatssolastseason.co.uk

 

[Pigster14]

Is the user actually still logged in? If so, have them log out and try again. If not, maybe see if they are locked up, unlock them and then try again. I don't think you can drop a user if they are logged in though.

Good Luck!