Losing dbobtions on clustered server failover?

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"Thomas Richards" <tom.richards@.rocketmail.com> wrote in message
news:f118866.0311060256.7f998697@.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.

Simonsql

Looking for SQL installation documentation on a clustered network

Hi,
I am looking for a SQL 2000 installation documention on a clustered network.
Online links/documentation is preferred than books.
Thanks,
Mehul
Here are several resources related to SQL Clustering, some for SQL 2000 and
some for SQL 2005.
Cluster -How to Configure Virtual Server 2005 in Order to Setup a Test SQL
Server Cluster
http://www.sql-server-performance.co...al_server1.asp
Cluster -Installing a Failover Cluster
http://msdn2.microsoft.com/en-us/library/ms179410.aspx
Cluster -Patterns and Practices, High Availability
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Cluster -SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Cluster -TechNet Support WebCast: How to cluster Microsoft SQL Server 2005
by using Microsoft Virtual Server
http://support.microsoft.com/default.aspx?kbid=891798
Cluster -Using Microsoft Virtual Server 2005 to Create and Configure a
Two-Node Microsoft Windows Server 2003 Cluster
http://www.microsoft.com/technet/pro...y/cvs2005.mspx
Cluster
http://www.microsoft.com/technet/pro...lus.mspx#EUEBG
http://www.microsoft.com/windows2000...ustersteps.asp
http://www.support.microsoft.com/?id=254321
http://technet2.microsoft.com/Window...mspx?mfr=true
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:AD991F6F-9707-439E-B305-6F9961DA70D4@.microsoft.com...
> Hi,
> I am looking for a SQL 2000 installation documention on a clustered
> network.
> Online links/documentation is preferred than books.
> Thanks,
> Mehul