Multiple Active Result Sets

Hi,
do u know
has sql server 2000 support MARS?

No, MARS is a new feature supported by SQL Server 2005.|||h?mm ok

i ve a db (sql server 2000). and i want to fill 3 collections from db at the same time. i think i can do it with using mars. but it's no supported SQL server 2000.

how can i do this in sql server 2000?

thanks.
|||

You might consider using a stored procedure that has all three queries.

Execute the stored procedure with a datareader object, using the NEXT resultset option to populate each of your collections.

Or upgrade to SQL 2005 and use MARS.

|||I think ? can't do it with using stored procedure. because i want to fill collections at the same time.
out of necessity i must use mars

|||

IF you are indeed using SQL 2000, you can NOT use MARS.

MARS is a new feature with SQL 2005.