Home » Interview Q&A » Kill Processes in sql server 2008

Kill Processes in sql server 2008

View in sql
User defined functions in sql

Kill Processes in sql server 2008

Hey folks till now we have discussed User defined functions in sql,   View in sql default constraint in sql , Remove Cross duplicate rows in SQLRecursive SQL Query , Recursive SQL Query-2STUFF and CONCAT in SQLRANK in SQL server , Difference between temporary table and table variable in sql serverUNIQUEIDENTIFIER in SQL ServerRAW Mode with FOR XML , AUTO Mode with FOR XMLEXPLICIT Mode with FOR XML , PATH Mode with FOR XMLOUTPUT Clause in SQL ServerDifference between delete and truncate in sql server etc.

Today we will discuss  regarding Kill Processes in sql server 2008. Many times we are in a position where we want to know all the running session or processes or query on particular database.  Some query may last longer until we explicitly kill it. So lets go through the first step of above problem to get all running session or processes.

The above query will return all the running session or processes on given database. Now to kill all this process use below query.

Now to cross check that all the processes had been killed, just run the first query again and see the output. It all goes right it will have no rows in the result set.

 

 

About

Hello friends, My self Dhruv Sheth, I have more than 6 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload CAPTCHA.




DISCLAIMER:
The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.