I read an article about deprecated features and sysindexes is marked as not supported under list "Features Not Supported in a Future Version of SQL Server" (system tables).
However I am surprised to see that sp_udpatestats procedure still uses sysindexes table for picking up rowmodctr column for verifying the indexes that got modified after last stats calculation, and this procedure is not using the new DMV's introduced in
SQL 2005 like physical index stats, stats calculated date, last_user_modified_date etc.
Also sp_updatestats is not marked for deprecation. When applications depending on SQL server are modifying the code/re-writting to move to the new catalog views/DMV's, I would expect SQL Server system stored procedures also get modified accordingly.
It's just a thought and never know if MS can consider this request...
View Complete Post