May 29, 2012

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

Total Pageviews