June 8, 2012

sp_script_reconciliation_xdelproc (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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_script_reconciliation_xdelproc(int @artid
, tinyint @publishertype
, nvarchar @publisher)

MetaData:

 create procedure sys.sp_script_reconciliation_xdelproc   
(
@artid int
,@publishertype tinyint=1 -- 1 = mssqlserver, 2 = heterogeneous
,@publisher sysname=NULL -- May only be non-NULL if @publishertype = 2
)
as
begin
declare @retcode int
--
-- security check
--
exec @retcode = sys.sp_MSreplcheck_publish
if @@error <> 0 or @retcode <> 0
begin
return (1)
end
--
-- call core function
--
exec @retcode = sys.sp_scriptdelproccore
@artid = @artid
,@format = 3 -- XCALL format
,@mode = 2 -- snapshot reconciliation mode
,@publishertype = @publishertype
,@publisher = @publisher
return @retcode
end

No comments:

Post a Comment

Total Pageviews