I write a stored procedure A in SQL Server6.5.<BR><BR>spA calls another 2 stored procedures,spB and spC, in sequence within spA. Both spB and spC runs a cursor to read 10 records from tableA. For each record read from tableA, a record in tableB is updated.<BR><BR>OK, i run spA in SQL Analyser and it works perfect and fast.<BR><BR>Now, I try to run spA from within ASP program and after executing spB, everything just hanged up. spC is not executed and spB is executed half the way.<BR><BR>This is what I code in my ASP:<BR><BR>strSql = " exec spA "<BR>set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Op en "DSN=Sample_DSN;"<BR><BR>set cmd = Server.CreateObject("ADODB.Command")<BR>cmd.Active Connection = conn<BR>cmd.CommandText=strSql<BR>cmd.Execute <BR><BR>Is it the problem of the ASP or ODBC or SQL6.5 ?<BR><BR>Regards,<BR><BR>Wilson<BR>