Thank you that worked perfectly!

Yes you are correct it's part of the trigger. Thank you for helping me see that! Unfortunately I can only suggest they change the linked database so most likely this...

I believe it's just poorly written sql. Here is the cursor piece:

DECLAREcur_Persons CURSOR FOR

SELECTpersonid

FROM@deletelist;

OPENcur_Persons;

FETCH NEXT FROM cur_Persons INTO @personid;

WHILE (@@fetch_status = 0)

BEGIN

DELETEdbo.Persons

WHEREid = @personid

FETCH NEXT FROM cur_Persons INTO @personid

END;

CLOSE...

Thanks!!! I'll check that out and attempt later this afternoon. It seems fairly straight forward so hopefully I'll be able to figure it out.

Turns out I had too many ' this worked: A.TrackingCode LIKE '%'+A.TrackingCode+'%'