sp_helpserver (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_helpserver(nvarchar @server
, varchar @optname
, varchar @show_topology)

MetaData:

 create procedure sys.sp_helpserver  
    @server         sysname = NULL,         --  server name  
    @optname        varchar(35) = NULL,     --  option name to limit results  
    @show_topology  varchar(1) = NULL       --  't' to show topology coordinates  
as  
    --  PRELIMINARY  
    set nocount on  
    declare @optbit     int,  
            @bitdesc    sysname,  
            @curbit     int  
  
    --  CHECK IF REQUESTED SERVER(S) EXIST  
    if not exists (select * from master.dbo.sysservers where  
        (@server is null or srvname = @server))  
    begin  
        if @server is null  
            raiserror(15205,-1,-1)  
        else  
            raiserror(15015,-1,-1,@server)  
        return (1)  
    end  
  
    --  GET THE BIT VALUE(S) FOR THE OPTION REQUESTED  
    if @optname is not null  
    begin  
        select @optbit = number from master.dbo.spt_values  
            where type = 'A' and name = @optname  
        if @optbit is null  
        begin  
            raiserror(15206,-1,-1,@optname)  
            return(1)  
        end  
    end  
    else  
        select @optbit = -1     --  0xffffffff  
  
    --  MAKE WORK COPY OF RELEVANT PART OF SYSSERVERS  
    select name = srvname, network = srvnetname, status = convert(varchar(100), ''),  
            id = srvid, srvstat = srvstatus, topx = topologyx, topy = topologyy,  
            collation_name = convert(sysname, CollationPropertyFromID(srvcollation, 'name')),  
            connect_timeout = connecttimeout, query_timeout = querytimeout  
        into #spt_server  
        from master.dbo.sysservers  
        where (@server is null or srvname = @server) and (@optname is null or srvstatus & @optbit <> 0)  
  
    --  SET THE STATUS FIELD  
    select @curbit = 1  
    while @curbit < 0x10000 --  bit field is a smallint  
    begin  
        select @bitdesc = null  
        select @bitdesc = name from master.dbo.spt_values  
            where type = 'A' and number = @curbit  
        if @bitdesc is not null  
            update #spt_server set status = status + ',' + @bitdesc where srvstat & @curbit <> 0  
        select @curbit = @curbit * 2  
    end  
  
    --  SHOW THE RESULT SET  
    if lower(@show_topology) <> 't' or @show_topology is null  
        select name, network_name = network,  
                status = isnull(substring(status,2,8000),''),  
                id = convert(char(4), id),  
                collation_name, connect_timeout, query_timeout  
        from #spt_server order by name  
    else  
        select name, network_name = network,  
                status = isnull(substring(status,2,8000),''),  
                id = convert(char(4), id),  
                collation_name, connect_timeout, query_timeout,  
                topx, topy  
        from #spt_server order by name  
  
    --  RETURN SUCCESS  
    return(0) --  sp_helpserver