Post reply

rows affected appear twice in message of a query result window

  • August 4, 2011 at 4:30 pm

    #241791

    When I run an update query to set 3 fields into a new value, it runs fine.

    My question is it shows in message window like 4 rows affected. And it appear twice.

    Why it shows twice of the same message intead of one?

    Thanks

  • August 4, 2011 at 4:33 pm

    #1364044

    Trigger?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 4, 2011 at 4:44 pm

    #1364047

    Yes, you are right, there is a trigger for auditing the table for update, insert , delete,

    Thanks!

  • August 5, 2011 at 1:24 am

    #1364121

    You can make the second "rows affected" disappear by adding SET NOCOUNT ON on top of the trigger.

    -- Gianluca Sartori

  • August 5, 2011 at 9:28 am

    #1364444

    Good to know, thanks

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply