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
StevodAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
arbertConnect With a Mentor Commented:
Nope, these options are stored in the master database....
0
All Courses

From novice to tech pro — start learning today.