SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell'

In this article, I will explain how I encountered the error “SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’.” Also, I will explain what I did to resolve this error. Problem: Recently, when I was working with SQL Server stored procedures, I wanted to create a stored procedure that creates a directory in …

Read more