-
Force a user to logoff ?
Hi all,
I got a login 'Jeff' with is password being "Hello" in the Security Logins from SQL Server. Let's say Jeff is currently logged in via an application in a random DB... I want to delete Jeffs login for XYZ reasons but the sp_droplogin procedure WILL fail because Jeff is already logged in in the DB... Is there a way to do something like this :
Logoff 'Jeff' -> Logs Jeff out of the DB
sp_dropLogin 'Jeff'
I want to be able to force a login name to be DISCONNECTED FROM THE DB so I can safely drop the login and he cannot connect back.... anyone heard of a way to do this ?
-
you could kill his connection
do an sp_who to get his spid and then kill <spid>
-
Ha ! that could do it, thx alot I'm trying it as soon as I can !!!!
Thx again !