June 8, 2012

sp_scriptdynamicupdproc (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_scriptdynamicupdproc(int @artid)

MetaData:

 create procedure sys.sp_scriptdynamicupdproc   
(
@artid int -- id of the article we are processing
)
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_scriptupdproccore
@artid = @artid
,@format = 2 -- MCALL format
,@mode = 2 -- dynamic scripting
,@publishertype = 1 -- SQL Server publisher
return @retcode
end

--
-- Name: sp_scriptvupdproc
--
-- Owner: KaushikC
--
-- Description: This procs is used for scripting VCALL update custom procedure
-- used for command distribution. Used specifically for updating subscriber articles.
-- Processing is similar to MCALL update procedure, in addition the version is also passed in
--
-- Parameter: Refer to the comments in the create procedure statement
--
-- Returns: 1 or 0 0 = success
--
-- Security: Public procedure - internal security check.
--
raiserror('Creating procedure sp_scriptvupdproc', 0,1)

No comments:

Post a Comment

Total Pageviews