Hi,
I have a connection timeout of 400 and command timeout of 0 for a stored procedure . the stored procedure retrieves a long data and store it in dataset.
I'm getting the "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." exception thrown on that stored procedure ... any ideas why it may happen . i'm using execute dataset