I am calling one procedure in SQL Server from my C# application. This procedure is returning 5 tables from the database. When the filter date is less its working fine from application. But when the between dates are high, its returning the tables in less than 5 milliseconds when i execute from database, but when i try to run the procedure from C# code and get a data set object its showing time out error. what may be the reason. can any one help.