Voss (voss_grose@hotmail.com) writes:
> Here's what's going on. I have a 2 computers (x & y) running SQL2000. I
> backed up a copy a DB from x and restored it on y. I have a Stored proc
> that runs in under 2 seconds on both x & y when running it through
> Analyzer, but when I call this stored proc running it throuhg my C#
> winforms app (running on computer z) it takes over 3 minutes on
> computer x and under 10 seconds on y.

Could you post the @@version for both SQL Server boxes?

As I understand there are three plans here. One you get in QA for both
procedures, and then you get two different ones from your C# application?
Of these three, which two did you actually post?

What happens if you from QA first run the command SET ARITHABORT OFF
before you run the procedures?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp