This script will kill all users in a given database. Before disconnecting, it can optionally send the user a NET SEND Message giving them a warning to disconnect. To run, simply call it like usp_killusers 'dbname'. Make sure the @dbname parameter is not the master database.
2001-08-08
4,468 reads
When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]
2001-08-08
3,046 reads
By Steve Jones
I had a customer recently ask about a change in one of their constraints...
This is not database related, so if you’re not interested in hearing about something...
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Comments posted to this topic are about the item fetch an execution plan from...
Is there a best practice way for the team to keep track of changes...
I have a query that is performing poorly It has a left join to...
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers