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
Tags: Databases & SQL