You administer a SQL Server 2008 instance. You plan to deploy multiple databases to the
instance. You design the security policy for the instance. A stored procedure verifies the
partition compression settings on each database deployed to the instance. You plan to use
a policy to execute the stored procedure. You need to ensure that the policy is enforced by
using Policy-Based Management Framework. What should you do?
A.
Grant EXECUTE permissions on the stored procedure to the
##MS_PolicyEventProcessingLogin## login.
B.
Enable the nested triggers server configuration option.
C.
Grant EXECUTE permissions on the stored procedure to the SQLAgent service account.
D.
Grant EXECUTE permissions on the stored procedure to the
##MS_PolicyTsqlExecutionLogin## login.