What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 9864 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 list all field names in the result set using mssql_field_name()?
What is the use of sql profiler in sql server 2012?
Does the unique constraint create an index?
Can I delete event logs?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to rename databases in ms sql server?
What is buffer cash in sql server?
Explain logical operators in sql server?
What will be the maximum number of index per table?
What is field with example?
Differentiate between SQL and ORACLE joins and write their syntax.
How do I create a stored procedure in dbml?
Is sql different from sql server?
What are the events recorded in a transaction log?
What is openxml in sql server?
