RE: [SQLDownUnder] Master database & oops part 2

[Greg Low]

Yes, certainly is. Dave's already submitted it further up the tree but I was just trying to see if anyone a) agreed and b) could see a problem with it.   Regards,   Greg

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Angus Logan
Sent: Thursday, 3 March 2005 7:41 PM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [SQLDownUnder] Master database & oops part 2

Completely agree!!!

 

Is there a sqlwish@xxxxxxxxxxxxx for product enhancements?

________________________________________
 
Angus Logan 
Product Specialist 
Microsoft Application Solutions
Data#3 Limited
P 07 3243 6323
F 07 3371 0188
M 0415 18 7778
E angus_logan@xxxxxxxxxxxx
W www.data3.com.au
________________________________________

 

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, 3 March 2005 7:38 PM
To: sqldownunder@xxxxxxxxxxxxxxxxxxxxxx
Subject: [SQLDownUnder] Master database & oops part 2

 

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

---

Details of Data#3's transmission content disclaimer can be accessed here - www.data3.com.au

---

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 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 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