Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

in my server i have 3 instances,one of them got failed, and
this cause we r not able to connect to server, how to know
which instance was dameged?

Question Posted / jagadeesh.polani21


in my server i have 3 instances,one of them got failed, and this cause we r not able to connect t..

Answer / sarojini makineni

Open SQL Server error log using notepad to know the Process
ID of respective instance of SQLservr.exe and stop such
process alone using Task Manager - (you may better download
procexp.exe to know the pid)

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what is hash table

3 Answers   ILFS, Teledata,

What is sql injection and why is it a problem? : sql server security

0 Answers  

What is SQL Server?

0 Answers   Atos Origin,

What do you mean by sql server 2005 express management tools?

0 Answers  

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,




Explain about integration services of Microsoft SQL server?

0 Answers  

Explain about link server in sql server?

0 Answers  

How to choose all records from the table?

0 Answers  

What happens if null values are involved in boolean operations?

0 Answers  

What command do we use to rename a db?

5 Answers   IBM,

What is sql server programming?

0 Answers  

Do you know what is xpath?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories