• While its often fun to think about how you might block a problem DBA from screwing up a database, the methods presented in this article won't do much practical to address the issue. The solutions presented here could very well end up doing more harm than good. Microsoft specifically states that modifications to system tables are dangerous and should be avoided. Putting a trigger on a system table could have consequences that were not expected or intended.

    I realize that at the end of the article you state that the techniques presented should not be used on a production database and hold little practical value; however, the lead-in to the article does not present the things in this light. While learning the structure of the system tables is useful, this article does not demonstrate any practical use of some potentially useful information. To me, it is dangerous and irresponsible to present, even momentarily, these techniques as a plausible solution to a very real problem.

    Chris Cubley, MCSD

    http://www.queryplan.com

    Chris Cubley

    http://www.queryplan.com


    Chris Cubley
    www.queryplan.com