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