sp_help_fulltext_catalog_components (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_help_fulltext_catalog_components()

MetaData:

 create procedure sys.sp_help_fulltext_catalog_components  
as  
    --  FULLTEXT MUST BE ACTIVE IN DATABASE --   
    if DatabasePropertyEx(db_name(), 'IsFulltextEnabled') = 0  
    begin  
        raiserror(15601,-1,-1)  
        return 1  
    end  
  
    --  dump all full-text components used in this database  
    select ftcat.name, ftcat.fulltext_catalog_id as ftcatid, componenttype, componentname, clsid,   
          (case when is_srvrolemember('serveradmin') = 1 then fullpath else NULL end) AS [fullpath],   
           version, manufacturer   
    from sys.fulltext_catalogs as ftcat cross apply sys.fn_ftcatcomponents(0, db_id(), ftcat.file_id) as ftcomp