Kill all Connections

  • Comments posted to this topic are about the item Kill all Connections

    Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.

  • We've been using this sproc for quite some time now, but we've been having the occational problem with it.

    Today my coleague suggested this:

    ALTER DATABASE MyDB

    SET SINGLE_USER

    WITH ROLLBACK IMMEDIATE

    which we're going to try.

    Is this wise?

    Best regards,

    Henrik

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

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