SAP Knowledge Base Article - Preview

3323849 - How to disable trigger firing in MS SQL Server replication - SRS

Symptom

  • How to disable trigger firing in MS SQL Server replication?
  • Set dsi_keep_triggers to 'off' encounter the following error in SRS:

    Message from server: Message: 195, State 0, Severity 15 -- '[[Message Iteration=1|Data Source Name=<DSN>|SQLState=42000|Native Error=195|Message=[...][SQL Server Driver][SQL Server]'triggers' is not a recognized SET option.]'. 


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Replication Server (SRS) 15.7.1
  • SAP Replication Server Heterogeneous Edition (RSHE) 15.7.1
  • SAP Replication Server Option (RSO) for Microsoft SQL Server 15.7.1
  • Microsoft Windows

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.