You need to detach the DB from SSE and start again.
Luckily I use SQL Server Management Studio which shows the currently attached DBs (connect to .\SQLExpress), and allows me to adjust the DB properties (under Options) and set the "Database Read-Only" attribute to False.
If you don't use SQL Server Management Studio, you can do this with SQL Server Express Utility (SSEUtil.exe), available at http://msdn.microsoft.com/data/downloads/tools/default.aspx
Comment by Mike D, on 9-Oct-2007 04:01
You can use sqlcmd which i think is built into sql express, the below script will switch off the read only status. sqlcmd -U sa -P PASSWORD -S .\SQLExpress -Q "alter database DATABASENAME set read_write" Soz in advance if i am barking up the wrong tree.
Comment by radu, on 8-Jan-2009 13:53
you just saved me allot of headache. thanks
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.