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_scriptsubconflicttable(nvarchar @publication, nvarchar @article
, bit @alter
, bit @usesqlclr)
MetaData:
create procedure sys.sp_scriptsubconflicttable (
@publication sysname
,@article sysname
,@alter bit = 0 -- if 1 script alter, otherwise script create
,@usesqlclr bit = 1
)
as
begin
declare @retcode int
--
-- Security Check.
--
exec @retcode = sys.sp_MSreplcheck_publish
if (@@error != 0 or @retcode != 0)
return (1)
--
-- Parameter Check: @publication.
-- The @publication cannot be NULL and must conform to the rules
-- for identifiers.
--
if (@publication IS NULL)
begin
raiserror (14043, 16, 2, '@publication', 'sp_scriptsubconflicttable')
return (1)
end
exec @retcode = sys.sp_validname @publication
if (@retcode != 0)
return (1)
--
-- Parameter Check: @article.
-- The @article cannot be NULL and must conform to the rules
-- for identifiers.
--
exec @retcode = sys.sp_MSreplcheck_name @article, '@article', 'sp_scriptsubconflicttable'
if (@@error != 0 or @retcode != 0)
return (1)
if LOWER(@article) = 'all'
begin
raiserror (14032, 16, 2, '@article')
return (1)
end
--
-- now call the SP to generate the script
--
exec @retcode = sys.sp_MSmakeconflicttable @article = @article, @publication = @publication, @creation_mode = 1, @is_debug = 0, @alter = @alter, @usesqlclr = @usesqlclr
return @retcode
end
No comments:
Post a Comment