DDL Triggers
dscotland
Posts: 7
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
Comments
Thanks for contacting us. I have raised this issue so that it will be considered in a future version of the software.