RE: Ad hoc updates to system catalogs are not enabled

From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 01/16/04

  • Next message: Alex Decarli: "Hide Databases" 
    Date: Fri, 16 Jan 2004 08:15:58 GMT

    Hi Peter,

    My name is Michael and I would like to thank you for using Microsoft
    newsgroup.

    Please try to perform the following SQL statements before you run the
    statements for adding the stored procedure.

    SP_CONFIGURE 'ALLOW UPDATES', 1
    RECONFIGURE WITH OVERRIDE

    After adding the stored procedure, please perform the following SQL
    statements for safe reason.

    SP_CONFIGURE 'ALLOW UPDATES', 0
    RECONFIGURE WITH OVERRIDE

    allow updates Option

    Use the allow updates option to specify whether direct updates can be made
    to system tables. By default, allow updates is disabled (set to 0), so
    users cannot update system tables through ad hoc updates. Users can update
    system tables using system stored procedures only. When allow updates is
    disabled, updates are not allowed, even if you have the appropriate
    permissions (assigned using the GRANT statement).

    When allow updates is enabled (set to 1), any user who has appropriate
    permissions can update system tables directly with ad hoc updates and can
    create stored procedures that update system tables.

    For more information regarding SP_CONFIGURE, please refer to the following
    article on SQL Server Books Online.
    Topic: "SP_CONFIGURE"
    Topic: "allow updates Option"

    Thanks for choosing Microsoft.

    Regards,

    Michael Shao
    Microsoft Online Partner Support
    Get Secure! - www.microsoft.com/security
    This posting is provided "as is" with no warranties and confers no rights.

  • Next message: Alex Decarli: "Hide Databases"

    Relevant Pages

    • Re: How do u ensure ur SBS updates are up-to-date and complete??
      ... No Windows updates does not give you all updates at this time, ... I subscribe to Microsoft security bulletin notifications. ... > give updates and hotfixes to not only SBS, but also SQL and ISA? ...
      (microsoft.public.windows.server.sbs)
    • Re: Genuine Advantage Notification - whats it doing every morning?
      ... As part of the update system the tool is checking for updates to itself, ... us it is pretty obvious that a tool that depends on communicating via the ... internet is going to, well, communicate via the internet:) ...
      (microsoft.public.windowsxp.general)
    • RE: Windows update not downloading
      ... I too am having considerable trouble. ... for the new update system downloaded fine, but when I click for updates, the ... reconnected, tried manual AND automatic modes, still no updates. ... but I scheduled the download and nothing happened ...
      (microsoft.public.windowsupdate)
    • getting updates
      ... Couldn't get SP2 until I got a download from ZDnet. ... now have gotten the " new " update system from microsoft. ... Cannot get any new updates at all. ...
      (microsoft.public.windowsxp.security_admin)
    • Re: windows update hanging
      ... Download stops or freezes. ... The Windows Update - Web Page Dialog window appears but download never starts ... Why can't I download updates? ... using the new update system, but cannot get beyond that point to download ...
      (microsoft.public.windowsupdate)