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