Very handy... thanks

It's got all the info I need, but thanks for reminding me to add indexes in there.

I was actually thinking I've seen a DMV or system view that has...

I have not seen this exact problem on SQL 2000 restores. I have encountered a similar problem in 2000 where when you restore the database that was published, it shows...

http://msdn.microsoft.com/en-us/library/ms188414.aspx

One thing to keep in mind, after upgrade from SQL 2000 to SQL 2005 or SQL 2008, it is best to run the following:

DBCC UPDATEUSAGE (0);

GO

this will prevent...

There is a SQL 2005 SP3, it's called SQL 2008!