Re: creating logins in stored procedure (yukon)

From: implacabile (implacabile_at_usa.net)
Date: 06/15/05 

Date: Wed, 15 Jun 2005 15:03:13 +0200

"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 ?

Relevant Pages

  • Re: application builder (activate activex)
    ... In version 7.1, select Tools>Build Application or Shared Library (DLL), then under the Application Settings tab click Enable Active X Server. ...
    (comp.lang.labview)
  • Re: default web site reinstall
    ... Disable Exchange Forms Based Authentication: ... Expand Server,, Protocols, HTTP ... Settings tab. ...
    (microsoft.public.windows.server.sbs)
  • Re: creating logins in stored procedure (yukon)
    ... >> Settings tab, then set the checkbox labeled Allow modifications to be ... >> made directly to system catalogs. ... > unfortunately I'm using sql server management studio from yukon, ... however I think it should be possibile to change the ...
    (microsoft.public.sqlserver.security)
  • Re: Error 18456: Login failed for user DOMAINuser
    ... When I use the Microsoft SQL Server Management Studio, ... Server access property is set to "Permit". ...
    (microsoft.public.sqlserver.security)
  • Could not find server
    ... I have linked a server withinh the "SQL Server Management Studio ... I also created a database where I created a view using the openquiery ...
    (microsoft.public.sqlserver)