Welcome to Bilal Haidar [MVP, MCT] Official Blog Sign in | Join | Help

SQL Server Express and Read-Only Databases

Several times, when I attach an existing database to SQL Server Express 2005, I get my database attached as read-only. So no way to add any object to it or update it!

The solution is to run this line:

Alter database <dbname> set read_write

As example would be: Alter database Northwind set read_write

This will make sure your database is now enabled for read/write!

 

Hope this helps,
Regards

Published Thursday, May 24, 2007 11:37 PM by BilalHaidar [MVP]
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: SQL Server Express and Read-Only Databases

Thank you :)

Thursday, October 02, 2008 1:47 AM by Jacob Sandin

Leave a Comment

(required) 
required 
(required)