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))
v
(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?
(SQL 2008)
[FooSupported] [int] NULL DEFAULT ((0)),
[Active] [int] NULL DEFAULT ((0))
v
(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?