I am supporting a VB6 developed system currently and i have an issue with one of my stored procedures which every so often timeouts through the application. the query its self is a very simple but does have a 3 unions, When i run the sp through query analyser it executes in .1 of second even when it is timing out thru the application.i initially thought it was the appliaction code but the ado connection code i use is standard across the application and this is the only sp that timeouts and also when i perform a sprecompile on the the sp, it runs fine through the application again, the frequency of of this happening is between every 2 - 5 weeks. there is no pattern to the time it occurs. i have tried droping and recreating the sp and also have created the sp under a new name and still this problem arises. this is the query that in the sp, Its just a list of all the products + 3 extra products that cannot be added to the products table. Select product from products union select 'PARTA' union select 'PARTB' union select 'PARTB' Any Suggestions???