title: Triggers and disabling "row(s) affected" message
body: <p>I have a trigger type INSTEAD OF Insert, Update.
  It looks something like below:</p>
  
  <pre><code>IF EXISTS(some select staement) 
   updade
   set
   where
   ELSE IF (some other select staement)
      insert
      values
   ELSE--(3)
  RAISERROR ('msg',16,1)
  RETURN; SET NOCOUNT ON;
  </code></pre>
  
  <p>The issue is that in 3rd - "else" option I would like to show only error message without any "row(s) affected" message.
  SET NOCOUNT ON dosen't work for me. I've already tried different configurations, put this with and without return. I was putted it everywhere in my statement.
  It doesn't work anywhere. I use SQL Server 2005 Can anybody help me please?
  <strong><em>Rows affected massage should appear always. The only exception is else statement.</em></strong></p>