Compare including statistics
vanram
Posts: 64
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
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