Hi, is there a way to log users out of SQL server at the start of my critical path and then allow them to log in once it has completed.
We have issues where users are locking tables using MS Access and our batch waits. If the users have left for the day, then we have to manage the situation manually.
asked Feb 25, 2014 at 08:49 AM in Default
OK, it's a heavyweight solution, forcibly disconnecting user sessions and rolling back any uncommitted transactions.
An example (from my post on bulk-restoring database backups):
The users are just reading the data so no updates at all.
I will look at the read_commit_snapshot option.
I plan to use the kill command along with a polite pre kill email. Then a final email once the batch has comlpleted....how nice am I!!
If it continues, then I will find a larger sledgehammer.
answered Feb 28, 2014 at 11:29 AM