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,824 reads

Blogs

Graph – Shortest Path

By

‘Shortest path’ is by far the most feature of SQL Graph for now. What...

Last Week Reading (2019-09-22)

By

Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...

Simple Graph Queries

By

In this post we saw how to create some graph tables with data. In...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Automate script for SQL Server Database backup

By VSSGeorge

I am writing a script for automating database backup, which is not working properly....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers