Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Altering Sync Framework Triggers RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Does it affect TRIGGERs ?

     

     

    -Ajinath

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