Wednesday, April 14, 2010

Databse is set to readonly when created a new copy or attached.

-Add the user "Network Service" in the folder where the mdf and ldf file is stored.
-Right click on the database name which is read only in sql server.
-Click on properties -> Options.
-Goto "State"
- Set the "Database Readonly" to false.
-Click on OK

No comments: