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_MSlocktable(nvarchar @ownername, nvarchar @tablename)
MetaData:
create procedure sys.sp_MSlocktable
(
@ownername sysname,
@tablename sysname
)
AS
begin
declare @retcode int
,@procname sysname
,@objid int
,@qualified_name nvarchar(300)
,@spretcode int
,@spcall nvarchar(256)
if @ownername is null
set @qualified_name= QUOTENAME(@tablename)
else
set @qualified_name= QUOTENAME(@ownername) + '.' + QUOTENAME(@tablename)
select @objid = object_id(@qualified_name)
if @objid is NULL
select @objid = object_id from sys.objects where name=@tablename
if @objid is null
return (1)
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @objid = @objid
if ((@retcode <> 0) or (@@error <> 0))
return 1
if 1=sys.fn_MSuselightweightreplication(null, null, null, null, null, null, @objid)
begin
--
-- For security: break ownership chain as
-- we have no control over the proc name is
--
select @procname= 'dbo.MSmerge_lws_sp_multi_' + procname_postfix from dbo.sysmergearticles where objid = @objid
and (1 = {fn ISPALUSER(pubid)})
select @spcall = N'exec @p1 = ' + @procname + N' @action = 4 '
exec @retcode = sys.sp_executesql @stmt = @spcall
,@params = N'@p1 int output'
,@p1 = @spretcode output
IF @@ERROR<>0 or @retcode<>0 or @spretcode != 0
RETURN (1)
end
else
begin
--
-- For security: break ownership chain as
-- we have no control over the proc name is
--
select @procname = 'dbo.' + select_proc from dbo.sysmergearticles where objid = @objid
and (1 = {fn ISPALUSER(pubid)})
select @spcall = N'exec @p1 = ' + @procname + N' @maxschemaguidforarticle = NULL, @type = 7 '
exec @retcode = sys.sp_executesql @stmt = @spcall
,@params = N'@p1 int output'
,@p1 = @spretcode output
IF @@ERROR<>0 or @retcode<>0 or @spretcode != 0
RETURN (1)
end
end
No comments:
Post a Comment