Hi there I'm a relative novice to SQL so I hope the answer to my question is not too complicated! I have designed an ASP.NET 2.0 application which uses a SQL backend. The user selects 3 or 4 parameters on the web page and then clicks to run a stored procedure in the SQL DB. The SP contains about seven queries which reads data from another SQL DB into the Application's DB. My problem is that the SP normally takes 1 to 2 minutes which is fine but sometimes it can take up to 10 minutes or more! Can anyone help me here please? Thanks in Advance Dave.