Showing posts with label execute windows command on SQL Server. Show all posts
Showing posts with label execute windows command on SQL Server. Show all posts

Tuesday, January 12, 2016

Enable master..xp_cmdshell extended stored procedure of SQL Server

master..xp_cmdshell used to execute windows command like cmd/PowerShell.

Execute below commands under master database to enable xp_cmdshell extended procedure

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;


You don’t have to do anything else to enable xp_cmdshell extended stored procedure.