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.

No comments:

Post a Comment