but that's just it...there are no errors...

and i'm using sa impersonation for the linked server

There is only one trigger

It does not. If I disable the trigger it does.

I appreciate the warnings, but altering the layout is not an option. This is what I've been given to work with. I'm working on a dynamic solution right now.

Here's a picture that I hope unmuddies it a little bit.