Re: Query Statment is Fast But Stored Procedure is Slow

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: San (anonymous_at_discussions.microsoft.com)
Date: 02/19/04 

Date: Wed, 18 Feb 2004 23:31:06 -0800

We tried with re-compile, drop and create the SP etc.. But nothing woks out except restarting the sql service.
Is there any document available to see all bugs in the latest ver of sql 2000?
This is happening once in a month in one of our SP.
Pls help me. In production environment it is very difficult to restart the service.

Thanks for you help
San

Relevant Pages