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_MSadd_dynamic_snapshot_location(nvarchar @publication, int @partition_id
, nvarchar @dynsnap_location)
MetaData:
create procedure sys.sp_MSadd_dynamic_snapshot_location ( @publication sysname, @partition_id int, @dynsnap_location nvarchar(255)) as set nocount on declare @retcode int exec @retcode = sys.sp_MSrepl_PAL_rolecheck @publication = @publication if @retcode<>0 or @@ERROR<>0 return 1 if @partition_id is NULL or @partition_id < 0 return 0 if exists(select * from dbo.MSmerge_dynamic_snapshots where partition_id = @partition_id) begin update dbo.MSmerge_dynamic_snapshots set dynamic_snapshot_location = @dynsnap_location, last_updated = getdate() where partition_id = @partition_id if @retcode <> 0 or @@error <> 0 return 1 end else begin insert into dbo.MSmerge_dynamic_snapshots (partition_id, dynamic_snapshot_location, last_updated, last_started) values (@partition_id, @dynsnap_location, getdate(), NULL) if @retcode <> 0 or @@error <> 0 return 1 end return 0
No comments:
Post a Comment