xp_cmdshell

• eboucicaut 94437

  Old Hand

  Points: 330

  More actions

  August 14, 2015 at 11:45 am

  #299772

  Hi ,

  please someone can help me with this error message:

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

  Msg 5808, Level 16, State 1, Procedure SP_BACKUP_DATABASES, Line 99

  Ad hoc update to system catalogs is not supported.

  i try to execute a cmdshell from sql server 2008

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  August 14, 2015 at 12:34 pm

  #1820185

  Have you read this article?

  https://www.mssqltips.com/sqlservertip/2875/how-to-allow-ad-hoc-updates-in-sql-server-system-catalogs/

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2