When i try to synchronise a database that contains DDL triggers the script always sets ansi_nulls and quoted_identifiers off.
I initially thought it must be me but I have checked sys.triggers and the DDL triggers in question have ansi_nulls and quoted_identifiers set to on but SQL compare insists on setting them off. This has been causing errors in synchronisations.
To get around this I either need to set ignore ansi nulls and quoted identifiers or open in the script in management studio and replace the offending set statements with the correct ones
Regards
David
I initially thought it must be me but I have checked sys.triggers and the DDL triggers in question have ansi_nulls and quoted_identifiers set to on but SQL compare insists on setting them off. This has been causing errors in synchronisations.
To get around this I either need to set ignore ansi nulls and quoted identifiers or open in the script in management studio and replace the offending set statements with the correct ones
Regards
David