I have a Webserver and a SQL server in same network. A certain stored procedure named ABC that is present on the SQL Server takes just 5 seconds to execute from the SQL Query Analyzer of Web Server. But the same sp times out when called from a .Net 1.1 web application of the Webserver. Time out parameter is 30 seconds. The data to be returned is less than 1000 rows. What could be the reason? Secondly, if I make a copy of the same sp with a new name, it works perfectly fine from the web application as well.