0

The issue is that there are certain users that keep certain applications open instead of shutting down their PCs overnight - this keeps locks on tables and that has an impact on other systems that rely on the tables being in an 'unlocked' state to do their updates etc.

I want to kill all USER connections (only) to a database. I will need to run this as a job on a nightly basis. I don't want to use:

ALTER DATABASE xxx SET SINGLE_USER WITH ROLLBACK IMMEDIATE

As I do not want to destroy the integrity of the database transaction logging.

Any ideas as to how this may be accomplished?

Thanks in advance,

JR

Jonathan
  • 11
  • 1
  • 3
  • 1
    "I do not want to destroy the integrity of the database transaction logging" - what are you talking about? – Damien_The_Unbeliever Jul 10 '14 at 06:38
  • possible duplicate of [What is the SQL command to forcibly close all other connections to the a database](http://stackoverflow.com/questions/2907598/what-is-the-sql-command-to-forcibly-close-all-other-connections-to-the-a-databas) – JotaBe Jul 10 '14 at 07:31
  • @"Damien_The_Unbeliever what are you talking about?" Whoops - I may have been thinking of 'simple' instead of 'single. – Jonathan Jul 10 '14 at 22:33

0 Answers0