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_cleanmergelogfiles(nvarchar @publication, nvarchar @subscriber
, nvarchar @subscriber_db
, nvarchar @publisher
, nvarchar @publisher_db
, nvarchar @web_server
, int @id)
MetaData:
create procedure sys.sp_cleanmergelogfiles( @publication sysname = '%', -- Publication name -- @subscriber sysname = '%', -- Subscriber server -- @subscriber_db sysname = '%', -- Subscription database -- @publisher sysname = '%', -- Publisher server -- @publisher_db sysname = '%', -- Publisher database -- @web_server sysname = '%', -- logs from IIS server -- @id int = -1 -- id of the log file to get data for -- )AS SET NOCOUNT ON -- -- Declarations. -- declare @retcode int declare @pubid uniqueidentifier declare @subid uniqueidentifier IF object_id('sysmergesubscriptions') is NULL RETURN (0) -- Security check -- EXEC @retcode = sys.sp_MSreplcheck_pull @publication = @publication, @raise_fatal_error = 0 if @@ERROR <> 0 or @retcode <> 0 return(1) -- -- Parameter Check: @publisher -- Check to make sure that the publisher is defined -- IF @publisher <> '%' BEGIN EXECUTE @retcode = sys.sp_validname @publisher IF @@ERROR <> 0 OR @retcode <> 0 RETURN (1) END -- -- Parameter Check: @subscriber. -- If remote server, limit the view to the remote server's subscriptions. -- Make sure that the name isn't NULL. -- if @subscriber IS NULL BEGIN RAISERROR (14043, 16, -1, '@subscriber', 'sp_cleanmergelogfiles') RETURN (1) END -- -- Parameter Check: @subscriber. -- Check if remote server is defined as a subscription server, and -- that the name conforms to the rules for identifiers. -- if @subscriber <> '%' BEGIN EXECUTE @retcode = sys.sp_validname @subscriber if @retcode <> 0 OR @@ERROR <> 0 RETURN (1) END -- -- Parameter Check: @publication. -- If the publication name is specified, check to make sure that it -- conforms to the rules for identifiers and that the publication -- actually exists. Disallow NULL. -- if @publication IS NULL BEGIN RAISERROR (14043, 16, -1, '@publication', 'sp_cleanmergelogfiles') RETURN (1) END delete mlf FROM dbo.MSmerge_log_files mlf, dbo.sysmergesubscriptions subs, dbo.sysmergepublications pubs where ( @id = -1 or @id = mlf.id) and pubs.pubid = subs.pubid and subs.pubid <> subs.subid and pubs.name = @publication and mlf.subid = subs.subid and mlf.pubid = subs.pubid and ((@web_server = N'%') or (mlf.web_server = @web_server collate database_default)) and ((@subscriber_db = N'%') or (subs.db_name = @subscriber_db collate database_default)) and ((@publisher_db = N'%') or (pubs.publisher_db = @publisher_db collate database_default)) and ((@subscriber = N'%') or (UPPER(subs.subscriber_server) = UPPER(@subscriber) collate database_default)) and ((@publisher = N'%') or (UPPER(pubs.publisher) = UPPER(@publisher) collate database_default)) return @retcode
No comments:
Post a Comment