Interested to Buy Any Domain ? << Click Here >> for more details...
What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10947 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / raghu
Consider there are transcations going on 1 row, some one is
trying to update a column in that row while others are
trying to retrive data of same row,while update locks the
row for some period of time others cannot select it, hence
deadlock occurs.
To kill the process is solution. In sql server 2005 use sql
profiler to view the process, in that see the column named
transactions if its value is more than 1 right click and
kill the process.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How to create a view with data from multiple tables?
Define indexes?
what protocol both networks use? : Sql server database administration
What is updatable resultset?
Which command is used for user defined error messages?
What is a document index?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What are built in functions?
what are the new features in SSRS?
How would we use distinct statement? What is its use?
What is named query? : sql server analysis services, ssas
What is delete query?
How to manipulate data from one table to another table ?
how can a database be repaired? : Sql server administration
what is difference between NULL and ISNULL in SQL Server 2008?
