Migrating from SQL Server 2000 to SQL Server 2008 R2 causes report to fail

[elsenorjose]

We're running a CR Server (XI R2 SP 2) where we have Crystal Reports running against a SQL Server 2000 (not sure of revision) database. We are migrating the database to a SQL Server 2008 R2 instance. One report in particular runs in about 30 minutes on the 2000 DB but on the 2008 instance, it takes over 1 1/2 hours. Same report file, CR generates the same SQL query, and when run via SQL Server Management Studio execution time is similar on both DBs. I've tried using OLE DB, SQL Native Client, and ODBC but no matter what I do, the report either takes forever to run or fails. Has anyone experienced any similar issues when pointing a Crystal Report to a SQL Server 2008 data source?

Thank you.

 

[Madawc]

Try Database > Show SQL for the two versions. If that gives you no clue, post them here.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[Madawc]

If you can run SQL directly, your software may include an option to show the percentages of time used in each process.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[PeterDimitrov]

Did you verify the database?

http://www.R-Tag.com

Tools for Crystal reports and SSRS.