May 2, 2012

sp_MSadd_dynamic_snapshot_location (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_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

Total Pageviews