Thanks for us response. i sorted out the above error. but now the issue is when De provisioning a scope i am getting the following error.
Additional information: Incorrect syntax near 'UNPIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'UNPIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
This is the code iam using
SqlConnection serverConn = new SqlConnection(ConfigurationSettings.AppSettings["DBServer"]);
SqlSyncScopeDeprovisioning serverSqlDepro = new SqlSyncScopeDeprovisioning(serverConn);
serverSqlDepro.DeprovisionScope("Filter_Scope_TB");