Error: 924 - Database "abc123" is open and can have only one user at a time.

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  December 4, 2012 at 3:17 am

  #267098

  I could not do anything on this server on any db, i get this same error on the server what ever i try do. this started happening after i have changed db "abc123" to single user mode and read only. any help?

  Now i could not make this db multiple user or kill any connections to this database for some reason.

• Sinfonico25

  SSC Veteran

  Points: 257

  More actions

  December 4, 2012 at 9:21 am

  #1565390

  I am wondering: what were you looking for?

  Try this:

  ALTER DATABASE [abc123] SET MULTI_USER WITH ROLLBACK IMMEDIATE

  GO

  ALTER DATABASE [abc123] SET READ_WRITE WITH NO_WAIT

  GO

  Post your query results.

  Hope it Help you