I want to be able to drop a login forcefully even if the login is currently logged on, its a SQL login. I have tried setting the database offline and online but that does not seem to do the trick, the way I do this is to restart the SQL service, but this
often require logging onto the server to do this, I was wondering whether there are other options other than restarting the service.
If I disable the login, the login is still connected because the connection persists from the application unless SQL is restarted or unless the application is restarted.
Any ideas ?
View Complete Post