Post reply

Temporary exclusive database access

  • November 2, 2015 at 3:21 pm

    #321889

    Comments posted to this topic are about the item Temporary exclusive database access

  • November 3, 2015 at 8:55 am

    #1837392

    We use this script for development databases and occasionally for refreshing a snapshot of a reporting database. It works great for us in those situations, but I advise caution if you plan to try this with your production OLTP mid-day. 😉

  • November 3, 2015 at 8:59 am

    #1837393

    This is my first script published at SQL Server Central. I plan to submit more scripts and articles in the future. You can also find me (and a lot of great people) at Ask SSC.

  • November 20, 2015 at 1:19 pm

    #1841454

    you get to be very careful. In a busy system, there are lot of threads would get access before you can get access, such as replication spids, log shipping, users connections from application connection pools etc.

  • November 20, 2015 at 3:10 pm

    #1841472

    Yes. I definitely advise caution before using any busy system like that, and that's why we just use it as a simple tool for our development environments.

  • November 23, 2015 at 1:32 pm

    #1841841

    Thanks for the script.

Viewing 6 posts - 1 through 5 (of 5 total)

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