Ad hoc update to system catalogs error

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  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.

• Gail Shaw

  SSC Guru

  Points: 1004494

  More actions

  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