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

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply