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_MSpostapplyscript_forsubscriberprocs(nvarchar @procsuffix)MetaData:
-- This proc is called by the .prc file to mark merge replication objects as system objects. create procedure sys.sp_MSpostapplyscript_forsubscriberprocs ( @procsuffix sysname) as begin declare @retcode smallint declare @procname nvarchar(400) declare @ownername nvarchar(140) declare @destowner nvarchar(140) declare @ins_procname nvarchar(258) declare @ins_batch_procname nvarchar(258) declare @upd_procname nvarchar(258) declare @upd_batch_procname nvarchar(258) declare @sel_procname nvarchar(258) declare @sel_metadata_procname nvarchar(258) declare @del_procname nvarchar(258) declare @conflict_proc nvarchar(258) set nocount on -- -- Check to see if current publication has permission -- exec @retcode=sys.sp_MSreplcheck_subscribe if @retcode<>0 or @@ERROR<>0 return (1) select @ins_procname = quotename('MSmerge_ins_sp_' + @procsuffix) select @ins_batch_procname = quotename('MSmerge_ins_sp_' + @procsuffix + '_batch') select @upd_procname = quotename('MSmerge_upd_sp_' + @procsuffix) select @upd_batch_procname = quotename('MSmerge_upd_sp_' + @procsuffix + '_batch') select @del_procname = quotename('MSmerge_del_sp_' + @procsuffix) select @sel_procname = quotename('MSmerge_sel_sp_' + @procsuffix) select @sel_metadata_procname = quotename('MSmerge_sel_sp_' + @procsuffix + '_metadata') select @conflict_proc = quotename('MSmerge_cft_sp_' + @procsuffix) select @procname = @ins_procname if object_id(@ins_procname ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end select @procname = @ins_batch_procname if object_id(@ins_batch_procname ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end select @procname = @upd_procname if object_id(@upd_procname ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end select @procname = @upd_batch_procname if object_id(@upd_batch_procname ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end select @procname = @del_procname if object_id(@del_procname ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end select @procname = @sel_procname if object_id(@sel_procname ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end select @procname = @sel_metadata_procname if object_id(@sel_metadata_procname ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end select @procname = @conflict_proc if object_id(@conflict_proc ,'P') is not NULL begin exec sys.sp_MS_marksystemobject @procname exec ('grant exec on ' + @procname + ' to public') end end
No comments:
Post a Comment