o.k thx i have create the trigger and stored procedure on ms sql side and run in period. the sp and it

works fine thx 🙂

Hi,

you mean I should create a trigger with (Del, ins and the upd Option) on ms sql table and then write the data to the Oracle table.

Just how can...

I think so in this style it would work but I have no idea with dynamic SQL can anyone help me here?

What is missing in the trigger?

CREATE TRIGGER [dbo].[trg_log_changes_france4]

ON...

Hi,

the Insert Statment works alone fine i have test it. I get the error with the Trigger !!

It is only a simulated disaster and want to proves that the mirrored data is correctly on backup server.

I can't use something like this becouse no support for ntext, text...

o.k sounds good. Since I am a beginner in SQL Server environment, how can I do that? Detailed description would be great.

THX

I been thereby to provide a solution, which will bee use in test case, to proves that the two DB's are equal. This can happen in following way. I create...

Thank you for the quick response but the prod DB is in time of a disaster point no longer available! for that reason I can't compare any table with an...