I attached a database with sp_attach_db but it ended being read-only. Is
there a script that can change my database from being read-only?
ALTER DATABASE pubs SET READ_WRITE
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
|||ALTER DATABASE dbname SET READ_WRITE
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
No comments:
Post a Comment