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?
- 1 Answers
- 4097 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Define master database?
When we should use @@error?
What are the difference between clustered and a non-clustered index?
What is a mutating table error and how can you get around it?
What the different components in replication and what is their use?
what is a deadlock? : Sql server database administration
Write a program using SQL queries to find a unique entry in a table.
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are the differences between stored procedure and the dynamic sql?
what stored procedure can you use to display the current processes? : Sql server administration
What is difference between drop truncate and delete?
What is the order by used for?
What is efficiency data?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to make remote connection in database?
