i have this test code<BR>&#060;%<BR>dim myconn<BR>myconn = "the connction string"<BR>set conn=server.createobject("ADODB.connection")<BR><B R>conn.Open myConn<BR>Set rs = Server.CreateObject("Adodb.Recordset")<BR>rs.Open "GetAllEmailIDForNewsLetter",conn<BR>%&#062;<BR>Ge tallemailfornewsletter is a stored procedure which returns 16-17 thousand records. And the line is giving a error of timeout expired after half minute. Is it that it cannot process so many records at a time or the stored procedure is not found or there r permission problems for stored procedure.<BR><BR>brij<BR>