I am creating an ADO recordset by executing SQL Server stored proecures. When the stored procedure does not use temporary tables, the recordset is created correctly. When the stored proc uses temporary tables, ASP returns the following error:<BR> ADODB.Recordset (0x800A0E78)<BR> Operation is not allowed when the object is closed.<BR>The line number of the error is first line in which the recordset is used. It appears the recordset is never opened. How can I create an ADO recordset returned from a stored procedure using temporary tables? I am new to SQL Server and appreciate any help on this.