The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_syspolicy_subscribe_to_policy_category(nvarchar @policy_category)MetaData:
CREATE PROCEDURE sys.sp_syspolicy_subscribe_to_policy_category
@policy_category sysname
AS
BEGIN
IF( @policy_category IS NULL)
BEGIN
RAISERROR(14043, -1, -1, '@policy_category', 'sp_syspolicy_subscribe_to_policy_category')
RETURN(1)
END
IF (IS_MEMBER('db_owner') != 1)
BEGIN
RAISERROR(21050, -1, -1)
RETURN(1)
END
DECLARE @dbname sysname
SET @dbname = DB_NAME()
DECLARE @ret int
EXEC @ret = [msdb].[dbo].[sp_syspolicy_add_policy_category_subscription]
@target_type = N'DATABASE',
@target_object = @dbname,
@policy_category = @policy_category
RETURN @ret
END
No comments:
Post a Comment