May 25 2007

SQL Server Express and Read-Only Databases

Category: Databases & SQLBil@l @ 09:37

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,


Comments are closed