Force a user to logoff ?

[1337_Vince]

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 ?

[fungi]

you could kill his connection

do an sp_who to get his spid and then kill <spid>

[1337_Vince]

Ha ! that could do it, thx alot I'm trying it as soon as I can !!!!

Thx again !