TCM-00787 giving error message: Unable to execute service UPDATE_DOCINFO_SUB and function lockContent

A issue with oracle IPM imaging workflow:(A SQL Server Issue)

Error: TCM-00787 giving error message
         

          WebCenter Content logs reporting deadlocks on SQL queries when using MS SQL Server as the backend database.

[FMWGEN][SQLServer JDBC Driver][SQLServer]Transaction  was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. java.sql.SQLTransactionRollbackException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction



CAUSE:

          When running WebCenter Content 11g, the database must have these two options enabled.

SET ALLOW_SNAPSHOT_ISOLATION ON
SET READ_COMMITTED_SNAPSHOT ON


SOLUTION:


The SQL Server database admin must execute these statements. Once these complete, restart the WebCenter Content managed server.
ALTER DATABASE <dbname> SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE <dbname> SET READ_COMMITTED_SNAPSHOT ON

Example statements, where the database name is DEV_OCS:
ALTER DATABASE DEV_OCS SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE DEV_OCS SET READ_COMMITTED_SNAPSHOT ON