locked
Altering Sync Framework Triggers RRS feed

  • Question

  • Hello,

              If I add 'SET NOCOUNT ON' statement in all the triggers & procedures created by Sync Framework, will it affect on the Sync?

     

     

    -Ajinath

    Tuesday, August 17, 2010 1:14 PM

All replies

  • i think you can safely insert the 'SET NO COUNT ON' statement. For the SPs, the @@ROWCOUNT would still be populated even if NO COUNT is ON.
    • Proposed as answer by JuneT Monday, August 23, 2010 8:17 AM
    Tuesday, August 17, 2010 11:58 PM
  • Does it affect TRIGGERs ?

     

     

    -Ajinath

    Thursday, August 19, 2010 1:27 PM
  • you can SET NO COUNT ON on the triggers as well.
    Thursday, August 19, 2010 2:08 PM
  • Thnaks JuneT.
    Friday, August 20, 2010 5:09 AM