"Mike Z." <aaa> wrote in message
news:442d8499$0$668$fa0fcedb@news.zen.co.uk...
> Has anyone seen that if you install SP4 on a SQL 2000 cluster that it will
> change the failover setting to affect the group regardless of its previous
> state? It doesn't do it for Full Text the first time you apply the SP but
> it will if you reapply the SP. It also sets the setting for "non-SQL"
> resources in your group like file shares. It seems to assume everyone
> wants "affect the group" as a default.
>
> Regards,
> Mike Z.
>

"Geoff N. Hiten" <SQLCraftsman@gmail.com> wrote in message
news:ekow6wPVGHA.1868@TK2MSFTNGP09.phx.gbl...
>I think that is a side effect of the SP install procedure. The procedure
>needs to have the cluster groups work a certain way or the install may
>break. I know it dislikes extra resource dependencies for the SQL Server
>service.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Mike Z." <aaa> wrote in message
> news:442d8499$0$668$fa0fcedb@news.zen.co.uk...
>> Has anyone seen that if you install SP4 on a SQL 2000 cluster that it
>> will change the failover setting to affect the group regardless of its
>> previous state? It doesn't do it for Full Text the first time you apply
>> the SP but it will if you reapply the SP. It also sets the setting for
>> "non-SQL" resources in your group like file shares. It seems to assume
>> everyone wants "affect the group" as a default.
>>
>> Regards,
>> Mike Z.
>>
>
>