Thank you very much for you help.

Wayne

Is there a better way to handle to do this?

I tried it again and it workd fine... Not sure what I was doing different to cause the error.

Thank you,

Wayne

Andras Belokosztolszki (2/1/2008)

---

You could just use the "WITH ENCRYPTION" when you create the trigger. For example:

CREATE TABLE mytable ( a INT )

GO

CREATE TRIGGER mytable_trigger ON mytable

WITH...

Thank you for your help,

Actually the Check_Hdr.Doc_No is unique and the Check_Line.Line is Unique.  The direct link between the tables in the Doc_No field.  In testing the code it works, it may...

oops it actually does work, my code wasn't completely right. 

I need to declare one of my variables correctly.

DECLARE @DocNO INT,

          @Line  INT,

          @TYPE  VARCHAR,       <---    @TYPE  VARCHAR(2),

          @RowsAffected INT

Thank...

Ok, I've tried what you posted, but it still didn't work.  If I use either one but not both of the updated statements, it will work.  Here is my code;

CREATE TRIGGER...