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