August 13th, 2013, 04:16 AM
Time out on procedure calling from C# code
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.
Do rate this post if it find useful to you
Click Here to Expand Forum to Full Width