sp_MSmerge_alterview (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_MSmerge_alterview(nvarchar @qual_object_name
, int @objid
, nvarchar @pass_through_scripts
, varchar @objecttype)

MetaData:

   
  
  
  
  
create procedure sys.sp_MSmerge_alterview  
(  
    @qual_object_name nvarchar(512) -- qualified 3-part-name              
    ,@objid    int  
    ,@pass_through_scripts nvarchar(max)  
    ,@objecttype varchar(32)  
)  
AS  
    set nocount on  
    declare @retcode int  
    declare @got_merge_admin_applock bit  
  
    select @got_merge_admin_applock = 0  
  
    if is_member('db_owner') <> 1  
    begin  
        raiserror (21050, 16, -1)  
        return (1)  
    end  
  
    begin tran  
    save TRAN sp_MSmerge_alterview  
  
    --  obtain the snapshot/DDL/admin proc applock to avoid having contention with snapshot  
    --  Attempt to get the lock with no wait  
    exec @retcode = sys.sp_MSgetmergeadminapplock @timeout = 0, --  no wait  
                                                  @lockowner = N'Transaction'  
    if @retcode<>0 or @@error<>0  
    begin  
        raiserror(21386, 16, -1, @qual_object_name)  
        goto FAILURE  
    end  
  
    select @got_merge_admin_applock = 1  
  
    -- loop through schema only publications/articles  
    exec @retcode = sys.sp_MSmerge_alterschemaonly @qual_object_name = @qual_object_name  
                                                ,@objid = @objid  
                                                ,@pass_through_scripts = @pass_through_scripts  
                                                ,@objecttype = @objecttype  
    if @retcode <>0 or @@ERROR<>0  
        goto FAILURE  
  
    -- merge does not have table based publications/articles for now  
    exec sys.sp_MSreleasemergeadminapplock @lockowner = N'Transaction'  
    commit tran  
    return 0  
  
FAILURE:  
    IF @@TRANCOUNT > 0  
    begin  
        if @got_merge_admin_applock=1  
            exec sys.sp_MSreleasemergeadminapplock @lockowner = N'Transaction'  
        ROLLBACK TRANSACTION sp_MSmerge_alterview  
        commit tran  
    end  
    return 1