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

Question Posted / jagadeesh

1 Answers
5383 Views
Verizon, I also Faced
E-Mail Answers

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

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers HCL,

explain the storage models of olap? : Sql server database administration

0 Answers

what is trigger . hw will it use them

2 Answers TCS,

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers

What is a transact-sql statement batch in ms sql server?

0 Answers

Can some one please help with a query which will take only max value of a column in a join.

2 Answers

What is difference between join and natural join?

0 Answers

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers

What is mean by candidate key?

0 Answers

Explain what are sparse columns?

0 Answers

How to declare and use cursor variables?

0 Answers

For more SQL Server Interview Questions Click Here