Failover Partner SQL 2005 Only?

[senfo]

I recently ran across the "Failover Partner" attribute that can be
assigned in the connection string and I was wondering if it worked with
SQL 2000 servers, as well as SQL 2005. I was reading this article
(http://msdn2.microsoft.com/en-us/library/5h52hef8.aspx) and there is no
reference to SQL 2000. It appears that support for failover partner was
added to the SqlConnection class as of .NET 2.0
(http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx)
so my assumption would be that the version of SQL Server is irrelevant,
however, I would just like clarification.

Will the failover partner attribute work if my database servers are
still running SQL 2000?

Thank you in advance,

 

[William \(Bill\) Vaughn]

Nope. And it won't work for SS 2005 until SP1.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[senfo]

Nope. And it won't work for SS 2005 until SP1.

Well that's a disappointment.

Thank you for the reply,