Thank you, That Did it.

Thanks.....

Thanks for the help. I will try them all and see which one gives me the best results.

Sorry, Actually they are not dropping the triggers, they are just disable and enabling them.

This triggers are in about 120 tables, so I need a global way to monitor this...

Thanks...

Just 2 things

1. Do you mean inside the first exec (exec ('use '+@dbname + update whatever....) or 2 separate Exec()

2. Why does it have to be, the update, in an...

I took this code from here somewhere and I modified it. Maybe this will help

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

/* How To use this Procedure

  exec sa_TraceTrigger @TableName =...

VFP = Visual FoxPro Version 6 or 7

I know those, But I used to do this in SQL7. It was something similar. I had to have the Query analyzer open with the store procedure on debug mode,...

Ok, That is what I plan to do, To transfer the informacion by CD daily. But this informacion that I transfer by CD will only be the changes since last...