Hi,

I come across some articles on SQL Server 2000 that
if we use transaction and didn't rollback or commit the
transaction due to improper coding or errors, it might
be 'locking' some tables in the database.

If that will to happen, is there any way to
rollback the old transaction ?

I know that using DBCC opentran will show any transaction not committed.

Anyone know of how to solve this issue.

Thank you