Stevod
asked on
Persistent database Options - How do I get them?
When I make a database read only using ALTER DATABASE <dbname> SET READ ONLY, or AUTO CLOSE, when I detach then re-attach the database, it loses the option setting i.e. reverts to read-write. Is there any way to make this persistent across attach/detach?
Many thanks
Stevod
Many thanks
Stevod
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.