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_MSunmarkschemaobject(nvarchar @object, nvarchar @owner)
MetaData:
create procedure sys.sp_MSunmarkschemaobject(
@object sysname,
@owner sysname = NULL
)AS
begin
set nocount on
declare @qualified_name nvarchar(517)
declare @id int
declare @retcode int
exec @retcode = sys.sp_MSreplcheck_subscribe
if @@error<>0 or @retcode <>0
return (1)
if (@owner is null or @owner = N'')
begin
select @owner = schema_name()
end
select @qualified_name = QUOTENAME(@owner) + '.' + QUOTENAME(@object)
BEGIN TRANSACTION
select @id = object_id(@qualified_name)
if not (@id is null)
begin
EXEC %%Object(MultiName = @qualified_name).LockMatchID(ID = @id, Exclusive = 1, BindInternal = 0)
-- EXEC %%Object(MultiName = @qualified_name).LockExclusiveMatchID(ID = @id)
if @@error <> 0
select @id = null
end
if not (@id is null)
EXEC %%Object(ID = @id).SetSchemaPublished(Value = 0)
COMMIT TRANSACTION
return 0
end
No comments:
Post a Comment