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_MSadd_repl_alert(int @agent_type, int @agent_id
, int @error_id
, int @alert_error_code
, varbinary @xact_seqno
, int @command_id
, nvarchar @publisher
, nvarchar @publisher_db
, nvarchar @subscriber
, nvarchar @subscriber_db
, ntext @alert_error_text)
MetaData:
CREATE PROCEDURE sys.sp_MSadd_repl_alert ( @agent_type int, @agent_id int, @error_id int, @alert_error_code int, @xact_seqno varbinary(16), @command_id int, @publisher sysname, @publisher_db sysname, @subscriber sysname, @subscriber_db sysname, @alert_error_text ntext ) AS begin SET NOCOUNT ON declare @retcode int declare @article sysname declare @article_id int declare @destination_object sysname declare @source_object sysname declare @publisher_id int declare @publication sysname declare @publication_id int declare @publication_type int declare @subscriber_id int declare @publisher_database_id int declare @agent_type2 int -- -- security check -- Has to be executed from distribution database -- if (sys.fn_MSrepl_isdistdb (db_name()) != 1) begin raiserror(21482, 16, -1, 'sp_MSadd_repl_alert', 'distribution') return (1) end -- Security Check if @agent_type = 3 select @agent_type2 = 0 -- distribution else if (@agent_type & 4 = 4) select @agent_type2 = 1 -- merge if @agent_type2 is not null begin exec @retcode = sys.sp_MScheck_pull_access @agent_id = @agent_id, @agent_type = @agent_type2 if @@error <> 0 or @retcode <> 0 return (1) end else begin if is_member('db_owner') = 0 begin RAISERROR (14126, 16, -1) return(1) end end select @publisher_id = srvid from master.dbo.sysservers where UPPER(srvname) = UPPER(@publisher) select @subscriber_id = srvid from master.dbo.sysservers where UPPER(srvname) = UPPER(@subscriber) select @publisher_database_id = id from MSpublisher_databases where publisher_id = @publisher_id and publisher_db = @publisher_db select @article_id = article_id from MSrepl_commands where publisher_database_id = @publisher_database_id and xact_seqno = @xact_seqno and command_id = @command_id select @publication = mp.publication, @publication_id = mp.publication_id, @publication_type = mp.publication_type from dbo.MSpublications as mp, dbo.MSsubscriptions as ms where mp.publisher_id = ms.publisher_id and mp.publisher_db = ms.publisher_db and mp.publication_id = ms.publication_id and ms.publisher_id = @publisher_id and ms.publisher_db = @publisher_db and ms.subscriber_id = @subscriber_id and ms.subscriber_db = @subscriber_db and ms.article_id = @article_id select @article = article, @destination_object = destination_object, @source_object = source_object from MSarticles where article_id = @article_id and publisher_id = @publisher_id and publisher_db = @publisher_db and publication_id = @publication_id INSERT INTO msdb.dbo.sysreplicationalerts (status, agent_type , agent_id, error_id, alert_error_code, time, publisher, publisher_db, publication, publication_type, subscriber, subscriber_db, article, destination_object, source_object, alert_error_text) VALUES (0, @agent_type, @agent_id, @error_id, @alert_error_code, getdate(), @publisher, @publisher_db, @publication, @publication_type, @subscriber, @subscriber_db, @article, @destination_object, @source_object, @alert_error_text) IF @@ERROR <> 0 BEGIN RETURN (1) END return (0) end
No comments:
Post a Comment