[SQLDownUnder] Master database & oops part 2

[Greg Low]

I was in an Ascend class with Bob Beachemin yesterday and saw yet another
person run a script in the master database when they meant to be elsewhere.
I realised you could now basically fix that with a DDL trigger in SQL Server
2005 (blogged about it at http://msmvps.com/greglow).

However, it struck me that I'd really like a server option that says
"Protect master schema" or something (as an advanced option), rather than
having to even set up a trigger. I mentioned it to one of the dev guys and
he seemed lukewarm yet every single person I've mentioned it to so far says
"oh yes yes please". I got Dave Lean to post a request on it last night but
I wanted to get your opinions.

Would that be useful? Can you see any problems?

I'm just figuring that 99.9% of DDL mods to master are in error and should
be prevented by default.

Thanks,

Greg

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net