Drop all connections to a SQL Server database with T-SQL

1 July, 2011 Roel van Lisdonk 0 Comments 1 category

If you want to drop all connections to a database by using T-SQL, connect Microsoft SQL Server Management Studio to the master database, open a new query editor window and execute the following T-SQL code:

/*
    Drop all connections to a database
*/

-- Take database offline
alter database [MyDatabase]
set offline with rollback immediate

-- Take database online
alter database [MyDatabase]
set online

Tags: SQL Server T-SQL

Category: Uncategorized

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Windows 8–Extraction progress window

6 January, 2012 Roel van Lisdonk 0 Comments 1 category

Just want to share a screen dump of the new…

Using Microsoft Outlook 2010 with BPOS without local *.ost file.

24 May, 2011 Roel van Lisdonk 0 Comments 1 category

Install Microsoft Outlook 2010, after installing don’t start Microsoft Outlook…

Dictionary lookup vs switch vs if performance in C#

28 August, 2013 Roel van Lisdonk 0 Comments 1 category

Lets say you want to execute a specific logging function…