Default values are being seen as different

ciaranarcherciaranarcher Posts: 28
edited July 12, 2011 10:35AM in SQL Compare Previous Versions
I am comparing a SQL Server 2008 R2 database running SQL Server 2000 compatibility mode with a SQL Server 2000 database. I keep seeing differences like this:

(SQL 2008)

[FooSupported] [int] NULL DEFAULT ((0)),
[Active] [int] NULL DEFAULT ((0))


(SQL 2000)

[FooSupported] [int] NULL DEFAULT (0),
[Active] [int] NULL DEFAULT (0)

Notice the double brackets.

when I create the sync script however, there are no changes to reflect these differences, so it;s like a false positive.

If I ignore Extended Props this seems to get rid of lots of them, but some still remain.

Can anyone help me with this?
Sign In or Register to comment.