SQL Server 2005 database in Read-only state= True, can't set to False
Posted on 2009-07-06
I have a SQL Server 2005 database moved from one machine to another and when moved Read-only = True; I can't set Read-Only to false via the interface, or by using either of the below:
ALTER DATABASE ASSCAP SET READ_WRITE,
EXEC sp_dboption 'ASSCAP', 'read only', false
Thanks in advance for any assistance.