CODEWITHSUNDEEP
sql-server
Dr. Rajesh Rolen
Dr. Rajesh Rolen

Reputation: 14285

How Can we implement MARS kind of functionality in SQL Server 2000

Previously i working on SQL Server 2005 and i used MARS functionality but currently i am working on a old project and they want SQL Server 2000 as a backend.. and i want MARS kind of functionality in it.. please tell me how can i do this.. frontend is (VB.NET)

Upvotes: 0

Views: 278

Answers (2)

gbn
gbn

Reputation: 432541

A stored proc can return multiple result sets that can be handled in client code.

Would this achieve the same result?

This also has the advantage of reducing round trips to the database

Upvotes: 1

Remus Rusanu
Remus Rusanu

Reputation: 294407

True MARS, no. You cannot execute a request while another request is still active in SQL 2000. You can bind multiple sessions into a single transaction and execute multiple requests from different sessions using sp_getbindtoken and sp_bindsession but each session has to execute one request, finish it and then a new session can execute a request on the same transaction, which is not what MARS is like.

Perhaps you can detail what you try to accomplish that you need MARS for. Perhaps you can substitute client side cursors for your needs?

Upvotes: 1

Related Questions