Applying SQL2005 SP2 CU9

• Sprout

  SSC Journeyman

  Points: 85

  More actions

  August 20, 2008 at 10:37 am

  #189656

  Before I apply CU_9 on SQL 2005SP2 the procedure stated to make sure that SMO and DMO XPs are enabled. To verify I run sp_configure on my Database Instance and do see SMO or DMO listed anywhere??

  any suggestions?

• thasteve

  SSCrazy

  Points: 2707

  More actions

  August 20, 2008 at 11:57 am

  #860811

  its an advanced option named 'SMO and DMO XPs' try

  sp_configure 'show advanced options', 1; reconfigure; sp_configure 'SMO and DMO XPs', 1; reconfigure;

• Sprout

  SSC Journeyman

  Points: 85

  More actions

  August 20, 2008 at 12:06 pm

  #860816

  I received the following msg:

  Ad hoc update to system catalogs is not supported

  Do I need to check the "cross database ownership changing box to allow this change?

  I also didn't see the XPs listed when I submitted:

  sp_configure 'show advanced options'

  What next?

  Thanks

• Sprout

  SSC Journeyman

  Points: 85

  More actions

  August 20, 2008 at 12:53 pm

  #860842

  I finally got it to work. I had to use the "RECONFIGURE WITH OVERRIDE" syntax.

  ex:

  sp_configure 'show advanced options', 1;

  GO

  RECONFIGURE WITH OVERRIDE;

  GO

  sp_configure 'SMO and DMO XPs', 1;

  GO

  RECONFIGURE WITH OVERRIDE;

  GO