Activity overview
Latest activity by msager
Joakim,
I have the same problem. Our DBA groups have maintenance jobs that make the STATISTICS_NORECOMPUTE flag differ from server to server. I encounter this problem regardless of whether my comparison is in version 3.1.7.218 or 5.2.0.32
I too am comparing two SQL Server 2000 databases. The one advantage of the newer version is that at least it tells you what the difference is. The older version flagged a difference, but when you drilled down to see what it was it only showed = signs. If I want to run a real comparison using this tool, I have to have my DBAs run this command in order to turn autostats back on and only then do a get a valid comparison.
EXEC sp_MSforeachtable @command1="print '?' EXEC sp_autostats '?', 'ON'"
It would be nice if this could be addressed.
Thanks,
Max / comments
Joakim,
I have the same problem. Our DBA groups have maintenance jobs that make the STATISTICS_NORECOMPUTE flag differ from server to server. I encounter this problem regardless of whether my com...