Failover Partner SQL 2005 Only?

  • Thread starter Thread starter senfo
  • Start date Start date
S

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,
 
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)
 
Back
Top