Thanks Hector, that's interesting.

Regards,

>Gary,
>
>I've run into instances where running stored procs from QA works fine, but it takes an eternity for the same stored proc to execute via VS.NET (or an .NET app)
>
>In our case, the problem was "solved" by clearing the stored procedure cache or restarting SQL Server. We ended up scheduling a job to clear the stored procedures cache every night.
>
>
>
>
>
>>Hi,
>>
>>I have been writing some T-SQL in VS.Net 2003. The code worked while debugging the sproc in VS.Net but when running the sproc, the code failed. It turned out that there was a timeout error. When I executed the sproc from SQL server's QA, the code works just fine.
>>
>>So, the timeout problem does not occur in QA but does occur in VS.Net. Any ideas where in VS.net I can alter the timeout to be the same as QA.
>>
>>Thanks,
>>
>>Best