Technical Article

Kill all Connections

There are times you want to kill all the connections in a database. This would do that trick. This can be very useful when you replace a database regularly and some connections still exist so your automated restore fails. You can issue this command to kill all the connections before issuing a restore command.

2002-04-17

2,426 reads

Blogs

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

SharePoint List only returns 100 items in Azure Logic App

By

I was reading a SharePoint List using the “Get Items” activity in an Azure...

Daily Coping 27 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Database backup and restore

By DBA

Hello, I've a user database which I want to migrate to new server, so...

Help Implementing Sample SQL Code

By carlton 84646

Hi community, I am trying to implement sample sql code: SELECT [LocalizedLabel] as [<COLUMN_NAME>]...

Error restore database in AZURE

By abdalah.mehdoini

Hello everyone, I created my SQL server Azure in PASS when i try to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers