hey guys

i attached adventure works in sql server 2008 and it showing as read only ,

so please guide me to make it read write or remove read only tag from database

 

thanks in advance

hey guys

i attached adventure works in sql server 2008 and it showing as read only ,

so please guide me to make it read write or remove read only tag from database

 

thanks in a

Execute the command 

ALTER DATABASE database-name SET READ_WRITE

 

VT

duplicate posting..

 

ALTER DATABASE database-name SET READ_WRITE

VT

thanks v.vt ,

i have given this command,its  taking to long its all ready one hours since i have given this command 

 

so is there any others option links .

Disconnect all users from the db and then..

Add WITH NO_WAIT

ALTER DATABASE database-name SET READ_WRITE WITH NO_WAIT

 

Hi,

Is there an error message while you attach (Or restore) the database if so please provide it.

If no Right click on your database choose properties -> go to options -> scroll to end then change read only option to false

 

I hope this is helpful.

 

Elmozamil Elamir

MyBlog

It might be too late to answer this query. I was having same problem updating Adventureworks2012 database in SQL Server 2012. After trying a lot of suggested answers I found out that I only had Read access to the folder in which I had downloaded the .mdf file and that was from where i had attached the database. So I dropped the database and re-attached from the folder which had read&write permissions and it worked out fine. Hope this helps.

• Marked as answer by Naomi NModerator Monday, April 07, 2014 2:30 AM

It might be too late to answer this query. I was having same problem updating Adventureworks2012 database in SQL Server 2012. After trying a lot of suggested answers I found out that I only had Read access to the folder in which I had downloaded the .mdf file and that was from where i had attached the database. So I dropped the database and re-attached from the folder which had read&write permissions and it worked out fine. Hope this helps.

• Marked as answer by Naomi NModerator Monday, April 07, 2014 2:30 AM

Perfect! This solution worked! 

Hey, 

I tried your solution it ran successfully but however my application still gives me the same error which is : 

System.Data.OleDb.OleDbException (0x80004005): Cannot update. Database or object is read-only.

Please help me 

• Edited by vritti rohira 1 hour 44 minutes ago

Hey, 

I tried your solution it ran successfully but however my application still gives me the same error which is : 

System.Data.OleDb.OleDbException (0x80004005): Cannot update. Database or object is read-only.

Please help me 

• Edited by vritti rohira Friday, June 19, 2015 5:23 AM

I had the read only issue with Adventureworks2012. 

ALTER DATABASE database-name SET READ_WRITE WITH NO_WAIT .... Didn't work or anything mentioned so far in this thread.

However,  I closed SQL Management Studio 2012.

Right clicked Icon from start menu and clicked Run as Administrator.

You can also select this permanently by going into Properties.

Hope this helps!!!!