You are likely to be falling victim to a behavior known as "parameter
sniffing" in SQL Server. See if this helps:
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.