I have database setup on one server using SQL 2005 now when I try to detach and attached that database on workstation with SQL Server Express 2005, it came up as Readonly message I get this message when try to alter database.
Message is "Failed to Update databse "database name" because the database is read-only. (Microsoft SQL Server, Error: 3906)".
Server: Windows 2003, SQL 2005, Database compatibility level is SQL Server 2000 (80)
Workstation: Windows XP Professional, SQL Express 2005, Compatibility level SQL Server 2005 (90)
Note: I am not able to change the compatibility level on workstation because its readonly.
Make sure the mdf file is not read-only