sp_server_info (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_server_info(int @attribute_id)

MetaData:

   
create procedure sys.sp_server_info  
(  
    @attribute_id  int = null  
)  
as  
    select * from  
    (  
        select  
            *  
        from  
            sys.spt_server_info  
  
        union  
  
        select  
            ATTRIBUTE_ID    = 16,  
            ATTRIBUTE_NAME  = convert(varchar(60), 'IDENTIFIER_CASE') collate catalog_default,  
            ATTRIBUTE_VALUE = convert(varchar(255),  
                                case when 'a' <> 'A' then 'SENSITIVE' else 'MIXED' end) collate catalog_default  
  
        union  
  
        select  
            ATTRIBUTE_ID    = 18,  
            ATTRIBUTE_NAME  = convert(varchar(60), 'COLLATION_SEQ') collate catalog_default,  
            ATTRIBUTE_VALUE = convert(varchar(255),  
                                'charset=' + convert(varchar(255), ServerProperty('sqlcharsetname')) +  
                                case when 0 = convert(int, ServerProperty('sqlsortorder'))  
                                then ' collation=' + isnull(convert(varchar(255), ServerProperty('collation')), ' ')  
                                else ' sort_order=' + convert(varchar(64), ServerProperty('sqlsortordername')) +  
                                     ' charset_num=' + rtrim(convert(char(4), convert(int, ServerProperty('sqlcharset')))) +  
                                     ' sort_order_num=' + rtrim(convert(char(4), convert(int, ServerProperty('sqlsortorder')))) end)  
                                collate catalog_default  
    ) as t  
    where @attribute_id is null or @attribute_id = attribute_id