Hi,
Thank for your feedback.
How do I check that zombi session exist using a watchdog ?
>>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.
Best Regards
Virusim