Failover Partner SQL 2005 Only?

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/li...tionstring.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,

--
Sean

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" <enceladus311@yahoo.comI-WANT-NO-SPAM> wrote in message
news:%23UKce1AMHHA.1276@TK2MSFTNGP04.phx.gbl...
>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/li...tionstring.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,
>
> --
> Sean

William (Bill) Vaughn wrote:
> Nope. And it won't work for SS 2005 until SP1.

Well that's a disappointment.

Thank you for the reply,

--
Sean