• Thanks for looking at this!  I feel vulnerable to attacks pasting my code : ).  This is just an example with raiserror.  I assume the rest of my code is irrelevant since it does not get past the @@ROWCOUNT statement.

    I got the "IF @@ROWCOUNT = 0 RETURN" deal from looking at other examples and I've always wondered why it would be in the front since a trigger obviously means something was updated.  I'm guessing the code you pasted is from BOL, and that makes more sense to me.  I'm recoding it that way right now.

    /* begin code */

    SET ANSI_NULLS ON

    GO

    SET ANSI_WARNINGS ON

    GO

    ALTER  TRIGGER UPDATE_LOGS ON [dbo].[myTable]

    FOR INSERT, UPDATE

    AS

    IF @@ROWCOUNT = 0

    BEGIN

             RAISERROR('RowCount is 0', 16, 1)

             RETURN

    END

    /* end code */