Thanks for the tip! I just found these as well with the step by step instructions, might be helpful to other guys:

How to: Uninstall an Existing Instance of SQL Server...

Any ideas on what is required to uninstall a SQL2005 instance that is running in a clustered set of servers?

Thanks!

We are not supposed to do it directly on SQL given that we want to centralize the backups/optimizations on Lite Speed. Have you guys seen similar issues by combining SQL2005...

thanks mate that worked!

Well, TFS is a product that some of us sooner or later have to integrate with SQL2005, so I guess you will hear from that more often in the future.

we are supposed to do CU10 first....so it is technically possible to go with SP3 right away?

I did not actually fix it but here's what a friend helping me out suggested:

So, I suggest:

a) Recoding the query in such a way that the...

thanks for the info mate...the issue was code related indeed