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_MSreset_synctran_bit(nvarchar @owner, nvarchar @table)
MetaData:
create procedure sys.sp_MSreset_synctran_bit ( @owner sysname, @table sysname )AS declare @qualified_name nvarchar(300) declare @tabid int declare @retcode int -- Security check exec @retcode = sys.sp_MSreplcheck_subscribe if @retcode<>0 or @@error<>0 return 1 if @owner = N'' select @qualified_name = @table else select @qualified_name = quotename(@owner) + '.' + quotename(@table) BEGIN TRANSACTION -- Unmark synctran bit select @tabid = object_id(@qualified_name) if not (@tabid is null) begin EXEC %%Object(MultiName = @qualified_name).LockMatchID(ID = @tabid, Exclusive = 1, BindInternal = 0) -- EXEC %%Object(MultiName = @qualified_name).LockExclusiveMatchID(ID = @tabid) if @@error = 0 EXEC %%Relation(ID = @tabid).SetSyncTranSubscribe(Value = 0) end COMMIT TRANSACTION return(0)
No comments:
Post a Comment