Interested to Buy Any Domain ? << Click Here >> for more details...
What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10814 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
What is the temp table?
What gets stored inside msdb database?
What is explicit cursors?
What is a sql join?
What is an expensive query?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
how to control the amount of free space in your index pages? : Sql server database administration
How to create nested stored procedure?
Can a table be created inside a trigger?
How to find tables without indexes?
How except clause is differs from not in clause?
What happens if you are trying to access a schema not owned by you?
What is SQL Azure Firewall?
How to delete an existing database user?
When to use null data driven subscription?
