How to configure replication triggers to SET NOCOUNT ON?

• Christian Crowhurst

  SSC Enthusiast

  Points: 132

  More actions

  April 6, 2007 at 3:12 am

  #172870

  Hopefully simple question:

  How to configure replication so that replication triggers issue a SET NOCOUNT ON?

  I'm not a DBA so my experience with replication is pretty much non-existent. Hopefully, there's a simple configuration option that I can apply when setting up replication for a database.

  Thanks in advance

  Christian

• Christian Crowhurst

  SSC Enthusiast

  Points: 132

  More actions

  April 9, 2007 at 3:09 am

  #699281

  Another question: are there any negative consequences of adding a SET NOCOUNT ON to replication triggers?

  Thanks

  Christian