ANSI_PADDING ON/OFF not detected as difference

slootwegp

SQL Compare 6.2.0.271
SQL Server 9.0.3175

when comparing tables it does not detect differences in tables created with ANSI_PADDING ON vs. OFF - Is there any way to change this behaviour? I looked at the Options and couldn't find anything to handle this.

Brian Donahue

Hello,

Since the ANSI_PADDING setting is defined on a connection, I'm not sure as to whether we can detect this sort of setting had been applied to a SQL object. I had, however, opened an issue with our developers about it, labeled SC-3252. So far, there hasn't been any movement on this issue since I had logged it last year.

slootwegp

I believe this corresponds to the value that is stored in .is_ansi_padded for sys.columns, sys.all_columns, sys.computed_columns, sys.system_columns and sys.identity_columns

It might get a bit weird for the case when a table is created with one setting and then altered with another - e.g. adding a field