Protecting the Master database from edits in Yukon

Kevin points to a useful script and resource for protecting the Master database from unintentional schema changes (by Greg Lowe).

1 Min Read
ITPro Today logo in a gray background | ITPro Today

One of my favorite blogs is put out by Greg Lowe.  I don't know Greg personally, but he always has good stuff. 

One recent posting he provided was a full T-SQL script that will protect the Master database of a SQL Server 2005 server from unintentional schema changes.  Greg puts forward the idea, and I agree, that 99% of the schema changes done to the Master database are done in error.  His script can protect your server from this problem!  Check out http://msmvps.com/greglow/.

Greg has also posted the slide decks for several good SQL Server 2005 sessioins including an "Introduction for Developers", "High Availability, Scalability, and Reliability", and "SQL Server 2005 Overview".  Good stuff, Greg!

Let me know if this is useful for you.

Thanks,

-Kev

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like