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_MSgetmergeadminapplock(int @timeout, nvarchar @lockmode
, nvarchar @lockowner)
MetaData:
create procedure sys.sp_MSgetmergeadminapplock @timeout int = -1, @lockmode nvarchar(32) = N'Exclusive', @lock_acquired int = NULL OUTPUT, @lockowner nvarchar(32) = N'Session' as set nocount on declare @retcode smallint declare @lock_resource nvarchar(255) declare @publisher sysname declare @publisher_db sysname declare @DbPrincipal sysname select @publisher = publishingservername() select @publisher_db = DB_NAME() select @retcode = 0 select @lock_acquired = -1 exec @retcode = sys.sp_MSreplcheck_publish if @retcode<>0 or @@ERROR<>0 return 1 -- use the dbowner role select @DbPrincipal = N'db_owner' select @lock_resource = N'MSinternal_repl_merge_admin_' + convert(nvarchar(6), db_id()) exec @retcode = sp_getapplock @Resource = @lock_resource, @LockMode = @lockmode, @LockOwner = @lockowner, @LockTimeout = @timeout, -- wait till the the given @timeout time to get it @DbPrincipal = @DbPrincipal if @@error<>0 or @retcode<0 -- lock was not acquired begin raiserror(20712, 16, -1, @publisher_db) select @retcode = 1 select @lock_acquired = -1 end else select @lock_acquired = 1 return @retcode
No comments:
Post a Comment