Re: creating logins in stored procedure (yukon)

From: Mark J. McGinty (mmcginty_at_spamfromyou.com)
Date: 06/14/05

  • Next message: Shachaf Ben-Tzur: "Re: Windows Authentication: how to setup" 
    Date: Mon, 13 Jun 2005 22:46:27 -0700

    "implacabile" <implacabile@usa.net> wrote in message
    news:uetxBjBcFHA.2756@tk2msftngp13.phx.gbl...
    >> that new stored proc. Just remember to set the option to allow changes
    >> to system tables before you create the new procedure, and set it back
    >> when
    >
    > how do I setup/remove that option?
    > thanks

    In EM, right-click the server opject, click Properties, click the Server
    Settings tab, then set the checkbox labeled Allow modifications to be made
    directly to system catalogs.

    Be aware that in so doing, you take full responsibility for the integrity of
    the system, so you'll want to be very careful.

    -Mark

  • Next message: Shachaf Ben-Tzur: "Re: Windows Authentication: how to setup"
    • Quantcast