468,272 Members | 1,999 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

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
Jul 20 '05 #1
1 1093

"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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Steve_CA | last post: by
1 post views Thread by news.microsoft.com | last post: by
1 post views Thread by theSpinel | last post: by
2 posts views Thread by Lyle Fairfield | last post: by
5 posts views Thread by pb648174 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.