Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4536 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
Why use identity in sql server?
What is multilevel indexing?
What is data modification?
What are the different types of cursor?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Can you index views?
Explain about Joins?
What is dynamic cursor in SQL SERVER?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Which are the olap features?
How to modify the underlying query of an existing view?
What is the difference between grant and with grant while giving permissions to the user?
Can we write trigger for view?
How to enforce security in sql server? : sql server security
What does <> symbol mean?
