In the real world, where all to often we do not get to ask follow up questions to design specs that may have been handed to us, the "BEST" answer...

If that were the case i think he would then have the problem for every execution, a problem that is reproducable (unless he is building dynamic sql, which is problematic...

This is more than likely not a sql issue, if it was your server rejecting connections (failed logon attempts etc) you would see exceptions on your sql instance.

Are you closing...

Gail, DO NOT GIVE IN.

We had a 6 month argument with our hosting company about the performance of their shared SAN environment. We were trying to implement 3 new clustered...

Do you have SP2 installed for SQL server 2005? There was a change in the calculations used for the size of the procedure cache.

http://sqlug.be/blogs/wesleyb/archive/2007/01/24/486.aspx

SQL Server 2005 RTM &...