Thanks, have checked that....was accessing the database server over the network...tried executing the same query from the database server and it was quick 4 sec the first run and zero...

Certain stored procedures had to be looked into.After changes were done,used sp_helptext (with results to text) to view the code of the stored procedure.Now when i run the sp it...

Thanks a lot Gail.I really appreciate your help.

Does this apply for all versions of sql server.Would i face this problem for sql server 2000 as well.