No, but these are test databases that have been restored from copies of live against which DBCC Checkdb has been run. I will run it and see what happens. Thanks...

Perry, Some of the databases in this server are 2000 compatible.

Hi Perry, I have attached the report. No this has always been a 2005 server which is the default instance. I do have a named instance of 2008 R2 installed...

Thanks Perry. I ran the upgrade advisor and have these issues. Do you have any idea how to go about fixing this, I spent a whole lot of time researching...

Thank you, these pointers help. After the upgrade can I switch the secondary database back to stand by read only mode? Thanks again.

I did this during off hours when no one else is accessing that table, hence I'm puzzled.

Thank you for replying. Do you know why the table size would increase though? If the pages are not getting deallocated because it is a heap, at least wouldn't it...