How can i execute one SO command inside a SQL Server 2000

• Jorge Mendes

  SSC-Addicted

  Points: 498

  More actions

  November 20, 2008 at 9:11 am

  #154936

  Hello,

  Can anybody tell me how can i execute one SO command inside a SQL Server 2000?

  I've tried to run the following command but it appears to me the following error.

  EXEC sp_configure 'show advanced options', 1

  GO

  RECONFIGURE

  GO

  EXEC sp_configure 'xp_cmdshell', 1

  GO

  RECONFIGURE

  GO

  GRANT EXECUTE ON xp_cmdshell TO [Domain\Username]

  GO

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

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

  The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.

  Can you tell me why it is happening and how can i resolve this situation.

  Thanks and regards,

  JMSM ;o>

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  November 20, 2008 at 11:48 am

  #901219

  Use RECONFIGURE WITH OVERRIDE

  DAB

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 20, 2008 at 11:56 am

  #901221

  In your original post, you indicated you are trying to do this on SQL Server 2000, correct?

  xp_cmdshell does not need to be configured on SQL Server 2000. That change occured with SQL Server 2005.