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)