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_MSchecksnapshotstatus(nvarchar @publication)MetaData:
create procedure sys.sp_MSchecksnapshotstatus @publication sysname AS declare @db_name sysname declare @retention int declare @retention_period_unit tinyint declare @snapshot_ready int declare @pubid uniqueidentifier declare @last_snapshot datetime select @snapshot_ready = NULL select @db_name = db_name() select @snapshot_ready=snapshot_ready, @retention=retention, @retention_period_unit = retention_period_unit, @pubid=pubid from dbo.sysmergepublications where name=@publication and publisher=publishingservername() and publisher_db=@db_name if @snapshot_ready is NULL select @snapshot_ready=snapshot_ready, @retention=retention, @retention_period_unit = retention_period_unit, @pubid=pubid from dbo.sysmergepublications where name=@publication if @snapshot_ready is NULL begin raiserror (21423, 11, -1, @publication) return (1) end -- -- Check to see if current publication has permission -- if ({ fn ISPALUSER(@pubid) } <> 1) begin RAISERROR (21423, 11, -1, @publication) return (1) end if @snapshot_ready=1 and @retention>0 begin select @last_snapshot=last_validated from dbo.sysmergesubscriptions where subid=@pubid if sys.fn_add_units_to_date(@retention, @retention_period_unit, @last_snapshot) < getdate() select @snapshot_ready=3 -- snapshot is obsolete -- end select @snapshot_ready
No comments:
Post a Comment