Losing dbobtions on clustered server failover?

[Thomas Richards]

We have a clustered sql server 2000 installation on windows 2000. We
recently lost the select into/bulkcopy option from a database. The
most likely candidate appears to be a failover just before - after
this happened the setting disappeared. Any ideas?

Thanks
Tom

[Simon Hayes]

"Thomas Richards" <to**********@rocketmail.com> wrote in message
news:f1*************************@posting.google.co m...

We have a clustered sql server 2000 installation on windows 2000. We
recently lost the select into/bulkcopy option from a database. The
most likely candidate appears to be a failover just before - after
this happened the setting disappeared. Any ideas?

Thanks
Tom

Can you clarify what you mean by "the setting disappeared"? Where did it
disappear from, and what happens if you use sp_dboption to set it directly?
Although MS now say that sp_dboption is for backwards compatibility only, so
perhaps you should look at using ALTER DATABASE instead, if that's possible.

If this issue only appears on clustered systems, you might want to post to
microsoft.public.sqlserver.clustering to see if anyone there has better
information.

Simon