Re: creating logins in stored procedure (yukon)

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

Date: Wed, 15 Jun 2005 09:02:08 -0700

"implacabile" <implacabile@usa.net> wrote in message
news:%232l9VqacFHA.2696@TK2MSFTNGP09.phx.gbl...
>
> "Mark J. McGinty" <mmcginty@spamfromyou.com> ha scritto nel messaggio
> news:%23xe%23xQKcFHA.3184@TK2MSFTNGP15.phx.gbl...
>>
>> "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
>>
>>
>
> unfortunately I'm using sql server management studio from yukon, and I
> cannot
> find the option. however I think it should be possibile to change the
> setting from
> sql, maybe using sp_configure ?

exec sp_configure 'allow updates', '1'

Quantcast