locked
Multiple Active Result Sets RRS feed

  • Question

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

    Thursday, March 29, 2007 8:09 PM

Answers

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

     

    MARS is a new feature with SQL 2005.

    Monday, April 2, 2007 5:48 AM

All replies

  • No, MARS is a new feature supported by SQL Server 2005.
    Thursday, March 29, 2007 11:22 PM
  • 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.
    Friday, March 30, 2007 6:02 AM
  • 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.

    Friday, March 30, 2007 8:05 AM
  • 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 Sad


    Saturday, March 31, 2007 6:40 AM
  • IF you are indeed using SQL 2000, you can NOT use MARS.

     

    MARS is a new feature with SQL 2005.

    Monday, April 2, 2007 5:48 AM