Thanks all for the help,  this will give me a few ways to look at the issue.  I still find it funny that MS doesnt publish the System Procedures (I've...

hard to follow what your asking?

first off - these columns I'm presuming are the following:

column 1 incremental numbers?

column 2 ID's?

first off you would need to know what the original value...

The purpose of a trigger is generally used to keep business rules set (validation on updates, inserts, deletions).  I dont believe its purpose is for calling stored procedures (but then...

Thanks for the feedback.

I believe the linkserver is the only way to include the access tables in a query via ADO.  Unfortunately the database that is being used cant be...

That is something I'd like better. I know the syntax for doing that with stored proc's : IF EXISTS (SELECT name FROM sysobjects WHERE name...

Thanks, for the help! I do have one final question though - after adding the link do I need to drop the link or anything like that?

Awsome, that should help a lot. Do you know if there is a way run a stored procedudre on the other server this way?

oops - got cut off.... the second variable would be..... select @XML_STRING2= substring(xmldata, 8001, 8000) from processlogdetail

I've basically had a similar problem where I'm parsing out xml that is stored in a text column - and the xml can be well over 8000 chars. I...