Home Forums SQL Server 2008 T-SQL (SS2K8) Enable 'Allow modifications to be made directly to the system catalogs' RE: Enable 'Allow modifications to be made directly to the system catalogs'

  • What is the purpose of removing that access from the public role? What is it you are trying to accomplish here?

    Take a look at VIEW DEFINITION in books online. I think that might be what you are trying to get at.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs