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_MSactivatelogbasedarticleobject(nvarchar @qualified_logbased_object_name)MetaData:
-- -- Name: sp_MSactivatelogbasedarticleobject -- -- Description: This procedure is called by the snapshot agent to activate -- a single logbased article object. -- -- Parameter: @qualified_logbased_object_name -- -- Returns: 0 - succeeded -- 1 - failed -- -- Notes: This procedure must be called within a user transaction or it -- will result in a no-op. -- -- Security: Public interface, will result in no-op if called by non-db_owner -- or non-replication agent. -- Requires Certificate signature for catalog access -- create procedure sys.sp_MSactivatelogbasedarticleobject ( @qualified_logbased_object_name nvarchar(517) ) as begin set nocount on if @@trancount < 1 return 1 if sessionproperty('replication_agent') <> 1 return 1 if object_id(N'dbo.syspublications', 'U') is null return 1 declare @retcode int , @is_replicated bit , @object_id int , @error int set @retcode = 0 exec @retcode = sys.sp_MSreplcheck_publish if @@error <> 0 or @retcode <> 0 return 1 set @is_replicated = null set @object_id = object_id(@qualified_logbased_object_name) select @is_replicated = is_replicated from sys.tables where object_id = @object_id if @is_replicated is null begin select @is_replicated = is_replicated from sys.views where object_id = @object_id end if @is_replicated = 0 begin exec %%Object(MultiName = @qualified_logbased_object_name).LockMatchID(ID = @object_id, Exclusive = 1, BindInternal = 0) set @error = @@error if @error <> 0 begin raiserror(@error, 16, -1) return 1 end exec %%Relation(ID = @object_id).SetReplicated(Value = 1) set @error = @@error if @error <> 0 begin raiserror(@error, 16, -1) return 1 end end return 0 end
No comments:
Post a Comment