If there is a possibility of recovering the data by comparing it from a duplicate database, go there before making matters worse. 

The answer they had I felt was wrong.

JOHN

Not sure if this is what you want it to do...

create table x (col1 numeric)

go

create table z (col1 numeric)

go

CREATE TRIGGER trigger_name

ON x

FOR INSERT, UPDATE

AS

If UPDATE(col1)

BEGIN

update z set...

Hey Justin,

Maybe extract the proc and try running it in query analyzer to see the query plan, and show server trace...? Just set @all_counters = 0 and run it....

Thanks for the reply. I just always feel like I'm missing something... and when I saw the patch come out this past April 17th, I started thinking, is...

I would probablly look into writing one query in the DTS Job using Linked servers running from ServerB. It would look something like this...

ON SERVERB...

Create Linked Server to ServerA...

You can also use workflow to alert you... If a step fails, then run this... I would also do what Steve suggested as well. But if it...