Drop all Connections from a Database

By Rahul Sharma, 2001/08/08

Total article views: 1517 | Views in the last 30 days: 137

Rate this |

Join the discussion |

Briefcase

On development servers, at times there is a need for dropping and renaming database(s). These scripts can be used for achieving these tasks. The usp_DropDB script will kill the connections to the database and then drop the database. It takes care of the space in the database name, if any and also makes sure that the database exists on the server.

By Rahul Sharma, 2001/08/08

Total article views: 1517 | Views in the last 30 days: 137

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Defrag Tables

By Rahul Sharma | Category: Maintenance and Management

| 3,227 reads

Forcibly Shrink the Transaction Log

By Steve Jones | Category: Maintenance and Management

| 6,320 reads

Recompile Compiled Objects

By wali | Category: Maintenance and Management

| 938 reads

Kill spids that are idle

By Steve Jones | Category: Maintenance and Management

| 3,245 reads

Like this? Try these...

Defrag Tables

By Rahul Sharma | Category: Maintenance and Management

| 3,227 reads

Kill spids that are idle

By Steve Jones | Category: Maintenance and Management

| 3,245 reads

Usp_GetProcByText

By Additional Articles | Category: Miscellaneous

| 349 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com