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_MSsetalertinfo(nvarchar @failsafeoperator, int @notificationmethod
, nvarchar @forwardingserver
, int @forwardingseverity
, nvarchar @pagertotemplate
, nvarchar @pagercctemplate
, nvarchar @pagersubjecttemplate
, int @pagersendsubjectonly
, nvarchar @failsafeemailaddress
, nvarchar @failsafepageraddress
, nvarchar @failsafenetsendaddress
, int @forwardalways)
MetaData:
create procedure sys.sp_MSsetalertinfo @failsafeoperator nvarchar(255) = null, @notificationmethod int = null, @forwardingserver nvarchar(255) = null, @forwardingseverity int = null, @pagertotemplate nvarchar(255) = null, @pagercctemplate nvarchar(255) = null, @pagersubjecttemplate nvarchar(255) = null, @pagersendsubjectonly int = null, @failsafeemailaddress nvarchar(255) = null, @failsafepageraddress nvarchar(255) = null, @failsafenetsendaddress nvarchar(255) = null, @forwardalways int = null -- 0 = forward only unhandled events, 1 = always forward events (both subject to @forwardingseverity) as -- only sysadmins are allowed to execute this stored procedure if( is_srvrolemember(N'sysadmin') = 0 ) begin RAISERROR (15003, -1, -1, N'sysadmin') return 1 end -- Set all alert info at one go, for performance reasons. Translate values if needed. -- if (@pagersendsubjectonly is not null and @pagersendsubjectonly <> 0) select @pagersendsubjectonly = 1 if (@failsafeoperator is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeOperator', N'REG_SZ', @failsafeoperator if (@notificationmethod is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertNotificationMethod', N'REG_DWORD', @notificationmethod if (@forwardingserver is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardingServer', N'REG_SZ', @forwardingserver if (@forwardingseverity is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardingSeverity', N'REG_DWORD', @forwardingseverity if (@pagertotemplate is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerToTemplate', N'REG_SZ', @pagertotemplate if (@pagercctemplate is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerCCTemplate', N'REG_SZ', @pagercctemplate if (@pagersubjecttemplate is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerSubjectTemplate', N'REG_SZ', @pagersubjecttemplate if (@pagersendsubjectonly is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerSendSubjectOnly', N'REG_DWORD', @pagersendsubjectonly if (@failsafeemailaddress is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeEmailAddress', N'REG_SZ', @failsafeemailaddress if (@failsafepageraddress is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafePagerAddress', N'REG_SZ', @failsafepageraddress if (@failsafenetsendaddress is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeNetSendAddress', N'REG_SZ', @failsafenetsendaddress if (@forwardalways is not null) exec sys.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardAlways', N'REG_DWORD', @forwardalways
No comments:
Post a Comment