Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing READ-ONLY property with Enterprise manager doesn't work

Status
Not open for further replies.
VitoMark

VitoMark

Programmer
Sep 25, 2001
20
BE
When I try to remove the read only property of a SQL 2000 database , using Enterprise manager (properties of a database), I receive this error message:
Error 5004: Tu use ALTER DATABASE, the databse must be in a writable state in which a checkpoint can be executed.
I can remove the read only state with sp_dboption stored procedure.
But why can't I use enterpise manager?
 
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question
return unique rows only
Replies
11
Views
599
Brianfree
Brianfree
ahmedsa2018
  • Locked
  • Question
How to export 20 milion rows to only one file ?
Replies
2
Views
316
JeffModen
JeffModen
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
1K
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
851
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top