what r steps to we need to fallow b4 kill the process?



what r steps to we need to fallow b4 kill the process?..

Answer / krishna reddy

first u know process number just run bellow command
sp_who it displays total process in your server..........
u don't kill your own process........Before killing process
Stop all executions in that process and give bellow
command........
kill n
kill processid

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain the ways to controlling cursor behavior?

0 Answers  


Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  


Why can there be only one clustered index and not more than one?

0 Answers  


Write an sql query to find first weekday of the month?

0 Answers  


What is difference between materialized view and view?

0 Answers  






What is the difference between getdate and sysdatetime?

0 Answers  


What are the advantages of using stored procedures?

0 Answers  


What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  


What is a non clustered primary key?

0 Answers  


Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  


How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,


What is nested transaction?

0 Answers  


Categories