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....
October 20, 2008 10:44 AM
October 21, 2008 12:36 AM