SqlDbx Forum

jnaz1

Member

DELETE and UPDATE don't seem to get commited

We've noticed the last couple of days that when executing an update or delete statement we lock the table. If we then enter a COMMIT TRAN the table becomes unlocked. We're using 4.10.1 going against Sql Server 10.50.1600.1. Anyone else seen this behavior? Is there an implicit commit setting that needs to be enabled? Thanks!

sqldbxhelp

Administrator

Re: DELETE and UPDATE don't seem to get commited

DELETE and UPDATE in SQL Server are implicit transactions.
I am not sure how you can have locks not released without BEGIN TRANSACTION.
And because you state that after COMMIT lock disappears it has to be BEGIN TRANSACTION somewhere