Script to drop all connections to a Database

Tijo Philip, , ,

There are instances when we may have to drop all the connections to a database for example to rename a database. The script below can be used to drop all the connections to the database. 

DECLARE @dbname nvarchar(128)

SET @dbname = ‘DB name here’ — db to drop connections DECLARE @processid int SELECT @processid = min(spid)

Read More . . . 

Published by Tijo Philip

Tijo is a business intelligence and SQL server developer.

4 Comments

  1. Pingback: Renaming MS SQL Server database « Awesome SQL
  3. Pingback: Dropping a subscriber database « just samson

  4. Pretty part of content. I simply stumbled upon your weblog and in accession capital to claim that I acquire actually loved account your blog posts.
    Anyway I will be subscribing to your feeds and
    even I success you get admission to constantly fast.

    Reply

Leave a comment