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 ?