Bruce Szabo


Technical Article

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

You rated this post out of 5. Change rating

2002-07-12

1,082 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Error in SQL Server Management Studio launcher

By Bcastro

Guys, good night! I have a situation in my SQL Server Management Studio where...

Just upgraded SSRS from 2016 to 2022

By LearningDBA

I just upgraded SSRS from 2016 to 2022. This is my first time doing...

Weekly sales report

By mailramk

I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers