May 14, 2012

sp_MSget_DDL_after_regular_snapshot (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_MSget_DDL_after_regular_snapshot(nvarchar @publication)

MetaData:

 create procedure sys.sp_MSget_DDL_after_regular_snapshot (  
@publication sysname,
@ddl_present bit output
)
as
declare @retcode int
declare @pubid uniqueidentifier
declare @schemaversion_of_snapshot_trailer int

exec @retcode = sys.sp_MSreplcheck_publish
if @retcode <> 0 or @@error <> 0
return 1

select @pubid = pubid from dbo.sysmergepublications
where name=@publication and upper(publisher)=upper(publishingservername()) and publisher_db=db_name()
if @pubid is NULL
begin
RAISERROR (20026, 16, -1, @publication)
return 1
end

select @schemaversion_of_snapshot_trailer = schemaversion from dbo.sysmergeschemachange
where pubid = @pubid and schematype = 52
if @schemaversion_of_snapshot_trailer is NULL
begin
raiserror(20652, 16, -1, @publication)
return 1
end

if exists (select * from dbo.sysmergeschemachange
where pubid = @pubid and schemaversion > @schemaversion_of_snapshot_trailer and
schematype in (11, 13, 300))
select @ddl_present = 1
else
select @ddl_present = 0

No comments:

Post a Comment

Total Pageviews