Facing a problem while working with transactions

5 pts.
Tags:
Database connectivity
SQL Server availability
SQL Server transaction logs
I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is disconnected, now the transaction is not committed nor rollbacked, so in this situation it gives me the problem on SQL Server which is on Machine A, i am not able to fire any query on that table it is being locked my queries goes into wait mode. What should i do to solve this problem.... Please help....

Answer Wiki

Thanks. We'll let you know when a new response is added.

This happens with the SQL Server sometimes when the client which is running the command is no longer available to confirm the rollback back.

Basically the SQL Server has tried to tell the client that it is going to rollback the command, but because the client isn’t there to say ok, the SQL Server is sitting there waiting for a response. This is one of the few time where you will need to restart the SQL service.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following