Month: November 2014

I created some examples of new C# with Visual Studio 2015. You can download and view them on GitHub (https://github.com/erossini/CS6-Preview). For more information about Visual Studio 2015, you can visit https://www.visualstudio.com/en-us/news/vs2015-preview-vs.aspx

In this tip we will take a look at the step to follow to enable or disable XP_CMDSHELL using SP_CONFIGURE system stored procedure. In order to use XP_CMDSHELL you need to be a system administrator. Read the following article which explains how to allow non-administrators to use XP_CMDSHELL. Error Message Received when XP_CMDSHELL is disabled You would end up getting the below mentioned error message when XP_CMDSHELL is disabled. Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1 SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’ because…

It is always considered as a best practice to disable XP_CMDSHELL when not in use. A database administrator can disable XP_CMDSHELL using SP_CONFIGURE system stored procedure. To disable XP_CMDSHELL execute the below mentioned script. Use Master GO EXEC master.dbo.sp_configure ‘xp_cmdshell’, 0 RECONFIGURE WITH OVERRIDE GO EXEC master.dbo.sp_configure ‘show advanced options’, 0 RECONFIGURE WITH OVERRIDE GO