We are constantly seeing a Process lock our SQL dbase with the statement 'IF @@ TRANCOUNT > 0 commit TRAN SET IMPLICIT_TRANSACTIONS OFF'

Whenever we kill the process the database starts processing other transactions and then this process comes back and the database becomes locked again.

We are running MS SQL 2005 and all of our ZCM servers are on SLES10 SP1

Has anyone seen this and if so do you know what caused it and how was it corrected?