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_processlogshippingmonitorsecondary(tinyint @mode, nvarchar @secondary_server
, nvarchar @secondary_database
, uniqueidentifier @secondary_id
, nvarchar @primary_server
, nvarchar @monitor_server
, bit @monitor_server_security_mode
, nvarchar @primary_database
, int @restore_threshold
, int @threshold_alert
, bit @threshold_alert_enabled
, nvarchar @last_copied_file
, datetime @last_copied_date
, datetime @last_copied_date_utc
, nvarchar @last_restored_file
, datetime @last_restored_date
, datetime @last_restored_date_utc
, int @last_restored_latency
, int @history_retention_period)
MetaData:
create procedure sys.sp_processlogshippingmonitorsecondary ( @mode tinyint -- 1 = add, 2 = delete, 3 = update ,@secondary_server sysname ,@secondary_database sysname = NULL ,@secondary_id uniqueidentifier ,@primary_server sysname = NULL ,@monitor_server sysname ,@monitor_server_security_mode bit ,@primary_database sysname = NULL ,@restore_threshold int = NULL ,@threshold_alert int = NULL ,@threshold_alert_enabled bit = NULL ,@last_copied_file nvarchar(500) = NULL ,@last_copied_date datetime = NULL ,@last_copied_date_utc datetime = NULL ,@last_restored_file nvarchar(500) = NULL ,@last_restored_date datetime = NULL ,@last_restored_date_utc datetime = NULL ,@last_restored_latency int = NULL ,@history_retention_period int = NULL ) as begin set nocount on declare @retcode int -- -- security check -- exec @retcode = sys.sp_MSlogshippingsysadmincheck if (@retcode != 0 or @@error != 0) return 1 -- -- This should be called only on the remote monitor server -- if (@monitor_server is null or upper(@monitor_server) != upper(@@servername) or upper(@monitor_server) = upper(@secondary_server)) return 0 -- -- must be invoked from MSDB -- if (db_name() != N'msdb') begin raiserror (21482, 16, -1, N'sp_processlogshippingmonitorsecondary', N'msdb') return 1 end -- -- call the internal proc now -- exec @retcode = sys.sp_MSprocesslogshippingmonitorsecondary @mode = @mode ,@secondary_server = @secondary_server ,@secondary_database = @secondary_database ,@secondary_id = @secondary_id ,@primary_server = @primary_server ,@monitor_server = @monitor_server ,@monitor_server_security_mode = @monitor_server_security_mode ,@primary_database = @primary_database ,@restore_threshold = @restore_threshold ,@threshold_alert = @threshold_alert ,@threshold_alert_enabled = @threshold_alert_enabled ,@last_copied_file = @last_copied_file ,@last_copied_date = @last_copied_date ,@last_copied_date_utc = @last_copied_date_utc ,@last_restored_file = @last_restored_file ,@last_restored_date = @last_restored_date ,@last_restored_date_utc = @last_restored_date_utc ,@last_restored_latency = @last_restored_latency ,@history_retention_period = @history_retention_period if (@retcode != 0 or @@error != 0) return 1 -- -- all done -- return 0 end
No comments:
Post a Comment