create procedure sys.sp_MStablenamefromnick
    @nick int,
    @qualified_tablename nvarchar(517) output,
    @pubid uniqueidentifier = NULL,
    @unqualified_tablename nvarchar(270) output
as
    declare @owner sysname
    declare @table sysname
    if (@pubid is null)
        select @table = name, @owner = SCHEMA_NAME(schema_id) from sys.objects where object_id in (select
            objid from dbo.sysmergearticles where nickname = @nick)
    else
        select @table = name, @owner = SCHEMA_NAME(schema_id) from sys.objects where object_id in (select
            objid from dbo.sysmergearticles where nickname = @nick and pubid = @pubid)

    select @qualified_tablename = QUOTENAME(@owner) + '.' + QUOTENAME(@table)
    select @unqualified_tablename = QUOTENAME(@table)
    if (@table is NULL) or (@owner is NULL)
    begin
        raiserror(21124, 16, -1, @nick)
        return (1)
    end
    return (0)