It seems that whatever I do, I can&#039;t get a recordset from a Command.Execute call. I&#039;m getting an error saying the returned recordset is closed when I try to read it.<BR>This is the code I use:<BR>set objCmd = Server.CreateObject("adodb.command")<BR>set objPrm = objCmd.CreateParameter("Periods", adVarChar, adParamInput, len(Request.QueryString("period")), Request.QueryString("period"))<BR>objCmd.CommandTe xt = "insert_into_Rep_Sup_Period1"<BR>objCmd.ActiveConn ection = objConn<BR>objCmd.Parameters.Append objPrm<BR>objCmd.CommandType = adCmdStoredProc<BR>objRS.Open objCmd<BR><BR>I also tried set objRS = objCmd.Execute, but it&#039;s the same.<BR><BR>The stored procedure runs ok, as it fills tables I need, and it does return rows on Query Analyzer. But still, no recordset is returned.<BR>What am I doing wrong?