Options

Compare including statistics

vanramvanram Posts: 64
edited May 30, 2008 4:05AM in SQL Compare Previous Versions
SQL 2000 - SQL Compare 6.2
I do not have statistics suppressed. I am comparing a table that has all columns with Statistics. On 1 side the table has 2 columns with the SQL generated names that start with '_WA_Sys_' and on the other just with the column name. The statistics otherwise are the same. SQL Compare does not show the '_WA_Sys' statistics, but does show the rest. Therefore what i see is all columns on 1 side with Stats and the other has all except 2 columns. I think i should see that the second side has the stats but with different names. Note: Statistics can be suppressed. Also when i look in Enterprise Manager/SSMS i see all the statistics!

Thanks

Comments

Sign In or Register to comment.