Thanks. I will try some of the scripts. Any suggestions?

I have 13 dev server that needs to be loaded with dev version as the previous installs was done with full versions.

Users on the boxes have old undocumented processes...

Thanks for the replies. I will do it the MS way then. I just hoped there was an easier way as there is alot of server I need to upgrade.

Hi

The problem is not the databases it is the actual users, operators ......

Is it possible to restore the system databases in 2008 r2?

I would delete the current log backup maint plan and recreate. Do it from the server that is running the SQL. SSMS can sometimes give errors when you work with...

Hi Dave

Yes sort off. The previous one was a comparison between the same query in 2000 and 2005 that ran totaly diff. This is same database diff TSQL. If you...

Hi Gail

Yes I have rebuilt all indexes and updated stats with full scan. All normal tasks have been run through. I personaly think this is a 2005 bug but I...

Hi

here is the scripts requested. I included stats.

Hi All

I scripted the database tables used with there indexes and recreated it on test server. I imported the data to new database but this also did not help. Execution...

Hi

Microsoft MSDN support gave me a link that suggested a update to CU9 and enabling traceflag 4199. This fix did not work for my problem, actually made it worse. After...

Thanks for all the replies. I will take it up with MS and designers of the app.

Hi Steve

Yes I did. I rebuild all indexes and updated all stats with fullscan. The difference I see is that SQL 2008 scans the Index on the bigest table first...

Actually I am looking for the reason why SQL 2000 would work ok and SQL 2008 not. There is hundreds of views queries and SP's in the database that comes...

Hi dave

Will rebuilding stats on views help? I do not see any stats on the views.

Hi Dave

Thanks for the suggestion. It did not work. The script is still running long (stopped it after 3 min). Do you perhaps know where I can log this for...