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_filteringcolumn(uniqueidentifier @pubid, int @tablenick
, nvarchar @column_name)
MetaData:
create procedure sys.sp_MSadd_filteringcolumn @pubid uniqueidentifier, @tablenick int, @column_name sysname as declare @retcode int , @objid int , @column_id int exec @retcode = sys.sp_MSreplcheck_subscribe if @retcode <> 0 or @@error <> 0 return 1 select @objid = objid from dbo.sysmergearticles where pubid = @pubid and nickname = @tablenick if @objid is not null begin select @column_id = column_id from sys.columns where object_id = @objid and name = @column_name if @column_id is not null begin insert into dbo.MSmerge_filteringcolumns_lightweight (publication_id, tablenick, column_id) select @pubid, @tablenick, @column_id where not exists (select * from dbo.MSmerge_filteringcolumns_lightweight where publication_id = @pubid and tablenick = @tablenick and column_id = @column_id) end end
No comments:
Post a Comment