News Ticker

[ July 20, 2020 ] Compare DB Objects Between two DBs Data Quality
[ June 17, 2020 ] Loop Through An Ordered List of Tables – Based On Foreign Keys DB Copy/Replication
[ June 11, 2020 ] Xml data type is not supported in distributed queries DB Copy/Replication
[ June 9, 2020 ] Merge Script Generator/In-house DB Replication Script DB Copy/Replication
[ June 9, 2020 ] DB Usage and Disk Space Info Server/DB Information

Enable xp_cmdshell

June 9, 2020 dataea5_wp Library, Server Configuration 0

-- this turns on advanced options and is needed to configure xp_cmdshell
sp_configure 'show advanced options', '1'
RECONFIGURE
-- this enables xp_cmdshell
sp_configure 'xp_cmdshell', '1' 
RECONFIGURE

Leave a Reply Cancel reply

Copyright © 2024 | MH Magazine WordPress Theme by MH Themes