With DMO, when you execute a SQL or stored procedure that returns data from multiple tables, it is stored in separate resultsets and you can tell how many by looking at something like '$resultref->ResultSets'... how is the same data returned when using ADODB.recordset? since you normally query using something like '$RS = $Conn->Execute($Sql)', does this one recordset contain the data from all tables (ie. all resultsets are returned via one recordset object)? or...??

any help is greatly appreciated!!

K.