I have a sql server installed on my machine and when I run the stored
procedure it gave me the result in 1 min but when I run the same stored
procedure in to different box it gave me the result in 20 min and that
machine has a higher configuration of mine machine, can any one guide me
which options i have to check for the SQL Server 2000 ?

Thanks in advance

Some questions to help clarify things:
-- when the query is running slower, is SQL on the same machine as the first
test, or a different machine / instance?
-- if it's on a separate machine, what else is installed and running on that
machine, and what are the specs;
-- if you're running against the same instance of SQL Server in both cases,
have you checked current activity in SQL or the OS to see what else is
happening;
-- did you change any parameters to the SP when you ran it the second time

David

[quoted text, click to view]