Maintenance and Management

Drop all Connections from a Database

  • Script

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 […]

5 (2)

2001-08-08

3,833 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Rebuild vs Reorganize

By sergey.gigoyan

Comments posted to this topic are about the item Rebuild vs Reorganize

Increase Query Speed with Covering Indexes

By steve@thesqlguy.com

Comments posted to this topic are about the item Increase Query Speed with Covering...

Data for Defense

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data for Defense

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers