Thanks for the replys guys. I think I'm going to go with the context idea in the link on the first reply. I can't change the table and...

Thanks, it worked great!

Thanks for all the replies. Unfortunately I don't have access to all the apps that write to the db so triggers are my only option. I can't make...

I went with the variable.

Do I need to destroy the var when exiting the trigger or will it destroy itself when it goes out of scope?

Thanks. It worked well.

I'm also getting an error at

SET @Doc = (SELECT Col1, Col2 FROM INSERTED As TableName FOR XML AUTO)

It says syntax error near XML

I didn't think that you could use...

Thanks for the info. I figured I would have to do an extended sp. I have a quick question about the @Doc. What happens if it is...

Thanks for the reply. I tried that earlier and couldn't find a way to get bcp to see the inserted table. I have to have access to the...