“xp_cmdshell” allow us to run windows commands by using SQL Server but first we need to enable it. We can check whether the “xp_cmdshell” configuration is enabled from the system table which contains server-wide configuration option value in the system.
Execute the following T-SQL will allow you to check if “xp_cmdshell” is enabled on a server. You may need to manually enable the “xp_cmdshell” function if the return result is not “1”.
SELECT CONVERT(INT, ISNULL(value, value_in_use)) AS config_value
endpoint security checklist endpoint security by bitdefender cannot be successfully installedTAGS
CATEGORIES