
	Home > Microsoft .Net Development Tips > Microsoft SQL Server > SQL script to kill all database processes

Win Development Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

MICROSOFT SQL SERVER

SQL script to kill all database processes

Parthasarathy Mandayam
10.21.2003
Rating: --- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

I have to restore production copies of my database daily onto development servers. Since the restore process requires exclusive access to the database, I have come up with this nifty SQL script to silently kill all users connected to the database. This procedure kills all database processes before restoring the database so that the restore process gets exclusive access to the database:

Usage:

...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server
	Using the Visual Studio 2005 DataSet Designer to build a data access layer
	The CTE, the hierarchical query and SQL Server 2005
	SQL Server 2005 recursive functions and the CTE
	Choose the right .NET data provider, optimize application performance
	The fallacy of the data layer -- or, a new architectural model for software designs
	Book excerpt: ADO.NET and SQL Server 2005
	Addressing common SQL Server questions
	Book Excerpt: The .NET Framework and SQL Server 2005
	WinForms development using SQL Server 2005 and Visual Basic 2005
	Configuring ASP.NET 2.0 apps to SQL Server 2005 databases

SQL Server and .NET development

Microsoft releases new CTP of Oslo SDK

Perpetuum unveils database synchronizer for .NET 2.0

The CTE, the hierarchical query and SQL Server 2005

SQL Server 2005 recursive functions and the CTE

SQL Examiner Suite synchronizes data schema, sets

Book excerpt: ADO.NET and SQL Server 2005

DataDirect database drivers now support MySQL

Top .NET tips of 2007 (so far)

Addressing common SQL Server questions

Book Excerpt: The .NET Framework and SQL Server 2005

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

...where test is the name of the database.

Reader Feedback

Sam B. writes: I have used this SQL script to create the procedure, successfully, but when I check the syntax of the exec line in Query Analyser I get an error near "Where". I have changed the 'test' to reflect the name of my database but still have no success. Please can you help? I must be missing something obvious!

Rate this Tip
To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Database Programming Solutions - .NET XML, Visual Studio LINQ, ORM .NET

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, TechTarget \| Read our Privacy Policy