I have an issue where the application is timing out when a stored procedure is called. The stored procedure when run from query analyzer returns results in few seconds, but gives timeout from application. The time out value is around 6 minutes in web.config. Can anyone help on what could be the reason for timeout error. This is happening only for certain functionalities in application and the rest are working fine without any issues.
...
Go to the complete details ...