Is there any way to retrieve the stored procedure return
value / output paramater values without having to close
the connection?

I'm trying to read the return value, before returning a
dataset, but if I close the connection to read the value,
the SqlDataReader is destroyed.

I'm using SQL Server 2000

Thanks in advance for any help.

Andrew