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?
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 |
Can we store videos inside the sql server table?
What do you mean by acid?
What Are Three Rules to UseĀ UNION IN SQL SERVER
What is purpose of normalization?
What is a fill factor?
Explain error and transaction handling in sql server?
What do you mean by collation recursive stored procedure?
What is the difference between clustered and a non-clustered index?
Explain logical operators in sql server?
What is the maximun sixes of .mdf in sql server 2005
How to see existing views in ms sql server?
How to find which stored procedure is currently running in sql server?