May 24, 2012

sp_MSreleasemergeadminapplock (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_MSreleasemergeadminapplock(nvarchar @lockowner)

MetaData:

 create procedure sys.sp_MSreleasemergeadminapplock  
@lockowner nvarchar(32) = N'Session'
as
begin
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(DB_ID())

--
-- Security Check.
--
exec @retcode = sys.sp_MSreplcheck_publish
if @retcode<>0 or @@error<>0
return 1

select @retcode = 0

-- 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_releaseapplock @Resource = @lock_resource, @LockOwner = @lockowner, @DbPrincipal = @DbPrincipal
if @@error<>0 or @retcode<0
return 1
else
return 0
end

No comments:

Post a Comment

Total Pageviews