Turning off the Messages

  • [font="Tahoma"]

    Hello Friends,

    I created an Instead Of Trigger for Insert. I added couple of Insert statements and one Delete Statement in the Trigger.

    Whenever i perform an Insert operation i am getting the Messages stating that number of records affected by the Insert & Delete Statements in the Trigger.

    Is there a way to turn off these messages? I have already included Set Nocount Off in the Trigger.

    Please help me on this....

    [/font]

  • You are almost there - it should be Set Nocount ON rather than off.

    Mike

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

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