Bruce Szabo


Kill Processes in a Database

This script kills all the processes using a given database.  It is useful for removing users from a database so it can be restored.To use this script change the server variable and the database variable at the top of the script.  Notifications are written to the windows application eventlog.Use this script at your own risk. […]

2002-07-12

1,072 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Daily Coping 14 May 2021

By

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

Read the latest Blogs

Forums

How can I tell where my Database encryption keys are kept

By cxmelga

Hello, can someone please help me with the following question, thanks in advance I...

UDF could not be bound

By Scott745618

Hi everyone, I have created a sum UDF and I cannot call  it. The...

Why doesn't the Secondary failover?

By FrankFarquar

Hi, I hope someone can help. I will try to summarise as best as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers