CODEWITHSUNDEEP
sqlsql-serversql-server-2008microsoft-sync-framework
Sergio
Sergio

Reputation: 9927

SQL Server: How to unlock a table / row?

We recently updated our WPF application to perform its data synchronisation (using sync framework) within a single transaction against our SQL Server 2008 database.

Almost straight away this has somehow led to a row being locked in of of the tables preventing all other users from syncing.

The thing is that the lock does not seem to be lifting and we are not sure how to resolve the situation.

Any feedback appreciated

Upvotes: 1

Views: 11070

Answers (1)

erikkallen
erikkallen

Reputation: 34411

The only way to release a row lock is to commit or rollback the transaction in which the lock was taken.

Upvotes: 5

Related Questions