>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

If a session remains open, you have to write a watchdog that execute a:

KILL

Normally a zombi session is detected and killed, but this is not guaranteed.