Enable xp_cmdshell in SQL Server

110
Views
1
Answers

How to Enable xp_cmdshell in SQL Server??

edit | flag
William Patrick
Asked on: Apr 15, 2013 at 7:14PM

1 Answers

162
1
162
-- To allow your 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 cmdshell.
EXEC sp_configure
'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
edit | flag
Gokul A
Answered on: Apr 15, 2013 at 7:26PM

Post your Answer

Search

Welcome to Ask Amoeba!
This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions.
Learners, beginners, Experts stop and share your knowledge and ideas!

Browse Categories

Browse Tags