RE: [SQLDownUnder] Master database & oops part 2

[Mitch Denny]

I certainly agree. I do this atleast once per week. You'd think I'd
learn right? The answer is ... No :) 







Mitch Denny
web:    http://www.readify.net
email:  mitch.denny@xxxxxxxxxxx
mobile: +61 (414) 610-141
blog:   http://notgartner.com
skype:  callto://mitchdenny

 
-----Original Message-----
From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx
[mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Greg Low
Sent: Thursday, 3 March 2005 8:44 PM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [SQLDownUnder] Master database & oops part 2

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
________________________________________ 

 

Angus Logan <http://msmvps.com/anguslogan/> 

________________________________

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 <http://www.data3.com.au/transdisc>  

________________________________

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 



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