I have got a stored procedure that returns either a return value (through the SQL RETURN statement) or a return value and a record. <BR><BR>I am able to use the command object to put in the correct Parameter values (the two inputs and the return value). And I am also able to execute the statement and retrieve the return values under any circumstance. <BR><BR>But (here is the problem) when I assign the return value of the executed statement to a recordset variable, the return value becomes undefined. ie., <BR>//doing: <BR>dbh_cmd.Execute() // is ok. But doing <BR>dbh_rs = dbh_cmd.Execute() // makes the return value undefined. <BR><BR>Is there some way to retrieve both with one invocation of the Execute method?