I have a stored procedure in SQL Server 7 that inserts about 600,000 records. I can run it in about 2 to 3 minutes in query analyzer. When I use it in ASP throught the ADO connection, I get an error:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error '80040e31' <BR><BR>[Microsoft][ODBC SQL Server Driver]Timeout expired <BR><BR>/schedule/addto911queue.asp, line 301 <BR><BR><BR>Line 301 is the one that calls the procedure.<BR><BR>I've tried setting the ConnectionTimeOut property as high as 100000 but I get this error after only about 30 seconds or so into the page execution. Any thoughts??