How can your resolve deadlocks?
Answer Posted / sasikala
one way to kill the process which is responsible for dead lock. after this the process can proceed without any problem. after a process completed , the killed process should be created and executed as if nothing has happened. but the killed process might have changed in an data base or some records. it must have changed as before to maintain the consistency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What command must you use to include the not null constraint after a table has already been created?
What is the current pricing model of SQL Azure?
How you would rewrite the sql query to return the customerid sorted numerically?
Does a specific recovery model need to be used for a replicated database? : sql server replication
How to modify an existing user defined function?
Who developed sql server?
What are triggers in ms sql server?
What are the tables in sql?
What is a db view?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is transactional replication?
How to find the service pack installed? : sql server database administration
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
What is snapshot report?