SQL Server Performance Forum – Threads Archive

Sysindexes in 2005

I have installed sqll 2005 and restored a sql 2000 database with complvl with 80. Now i did a updatestats and everything possible but the rowmodctr column is not reset. Has anything changed the wat this counter workes? Thanks

Change the compatibility to 90 in order to take all the updates,http://msdn2.microsoft.com/en-us/library/ms190283.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

rowmodctr is accessed from another system table which is not available for regular user…
Sysindexes is the view not a table in sql 2005…
And irrespective of your cmpt level you should see the same…
Try after running DBCC UPDATESTATS…
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>