KevinC. (4/15/2010)
Interesting question.Also thanks, Jason, for the extra info on new databases not inheriting the READ_ONLY setting. I would not have expected this behavior.
--
Kevin.
I had to try it since the setting could be set. I wanted to see if a READ_ONLY setting would be enforced in a new database. I expected that it would and thus cause some problems (say you run a script to create your database and then perform the necessary database settings, add files, or create objects) and then you run into errors because the database would have been READ_ONLY. Alas, my suspicion was wrong and the setting does not get enforced.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events