Skip to content

Instantly share code, notes, and snippets.

@ashishkudale
Created June 11, 2018 17:43
Show Gist options
  • Save ashishkudale/56b7e500deecff2053a39559f97cdb65 to your computer and use it in GitHub Desktop.
Save ashishkudale/56b7e500deecff2053a39559f97cdb65 to your computer and use it in GitHub Desktop.
following commands are for enabling xp_cmdshell.
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1;
GO
-- To update the currently configured value for advanced options.
RECONFIGURE;
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1;
GO
-- To update the currently configured value for this feature.
RECONFIGURE;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment