What are the challenges you face when working across database platforms? Take the survey
Options

DDL Triggers

dscotlanddscotland Posts: 7
edited March 31, 2006 7:18AM in SQL Compare Previous Versions
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

Comments

Sign In or Register to comment.