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 or should I try a different method of retrieving return values.