Remove LockacquisitionException in SQL

**sbharate** · Feb 5 '14, 07:49 AM

How can I avoid Lockacquisition Exception in SQL.

My code is :

Code:

ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT OFF;

SELECT is_read_committed_snapshot_on FROM
sys.databases WHERE name= 'YourDatabase'

Which similar type of SQL quy (sic - key?) should be used to avoid Lockacquisition Exception ???

Please help on this.
Thanks in advance.