I want to create a policy which enables xp_cmdshell for a specific database. When I choose Database or DatabaseSecurity as my facet I don't get a choice for xp_cmdshell. When I choose ServerSecurity I do.
I've also tried setting it up as a ServiceAreaConfiguration facet but then I don't see anything to select in "targets".
Bottom line, can I enable this for a specific DB or can I only enable it server wide?
As you suspect, the xp_cmdshell option (http://technet.microsoft.com/en-us/library/ms190693.aspx) is a server-wide configuration option, and isn't configurable at the database level. If enabled, xp_cmdshell
With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…