Trying to enable xp_cmdshell on sql 2000, but getting the following error: "
The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option."
Trying to run the following
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
-- To update the currently configured value for advanced options.
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
-- I get the error after I run the above stmt.
-- To update the currently configured value for this feature.
I checked the version: 8.00.2039
Anyone have any ideas?