Hi, I want to use "SQL Server 2008" for Master/Slave configuration. However it is not allowing to have database locks with exception as below :
ERROR | Failed to acquire lock: com.microsoft.sqlserver.jdbc.SQLServerException: A processing error "Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR." has occurred. com.microsoft.sqlserver.jdbc.SQLServerException: A processing error "Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR." has occurred. Can anyone please help? Thanks, Sheetal.