Reports are running slow after SQL server upgrade

[mnasuto]

Hi,

I am using SQL 2000 and Crystal 8.
Recently we have upgrated SQL server.
After server change reports are running very slow.
SErver setup looks identical to server befor upgrading.
All reports are running on Stored procedures.
Stored Procedures are running quick.
There is problem with reports.

Please help if you can.

Marta

 

[synapsevampire]

You might try the Database->Verify Database within Crystal and then save the report again. I haven't heard of this particular issue, especially in light of the SPs running quickly, so it does sound like a Crystal concern.

Are the reports run from the Crystal Reports gui or external code?

-k

 

[mnasuto]

Thank a lot for replay.
My reports are running from bespoke applicaion and Crystal is on different server then SQL database. As you suggested
I will check if application cosing a problem.