I have also seen this behavior… a sp works great in Query Analyzer, but when it runs thru the app it’s performance drops dramatically…. Looks like everyone is looking in...

No. All I have is SQL version 7.0.

quote:

---

Do you have the SQL Server 2000 client tools available?

K. Brian Kelley

bkelley@sqlservercentral.com