T-SQL: Quickly Kick All Users Out of a SQL Server Database

calendar Jan 30, 2007  · Updated: November 3, 2025 · 1 min read  ·
Share on: linkedin bluesky copy

There are a few ways to do this but here's one that I like. I believe it works in SQL Server 7, 2000 and 2005.

1ALTER DATABASE myDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
2GO
3USE myDatabaseName
4GO

Go ahead and do what you need to do then set it back:

1ALTER DATABASE myDatabaseName SET MULTI_USER