Post reply

Ad hoc update to system catalogs error

  • October 4, 2013 at 5:21 pm

    #298591

    hi i have an instance Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) (Build 3790: Service Pack 2) . i am admin to this box, i need to enable database mail but when trying to enable by:

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Database Mail XPs', 1;

    GO

    RECONFIGURE

    GO

    I get error:

    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

    Msg 5808, Level 16, State 1, Line 1

    Ad hoc update to system catalogs is not supported.

    Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51

    The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option.

    Msg 5808, Level 16, State 1, Line 1

    Ad hoc update to system catalogs is not supported.

  • October 4, 2013 at 5:26 pm

    #1656068

    Run

    EXEC sp_configure 'show advanced options', 1;

    go

    EXEC sp_configure 'allow updates', 0

    GO

    RECONFIGURE

    GO

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply