Temporary exclusive database access

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

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

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

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

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

  • Thanks for the script.

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

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