Facing a problem while working with transactions
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....
Software/Hardware used:
Software/Hardware used:
ASKED:
October 20, 2008 10:44 AM
UPDATED:
October 21, 2008 12:36 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
