SELECT OBJECT_NAME(C.[Object_ID]) 'Table Name', COL_NAME(C.[OBJECT_ID],C.Column_Id) 'Column Involved', L.Alias 'Language Used' FROM sys.fulltext_index_columns C JOIN SYS.SysLanguages L ON (C.Language_ID = L.LCID)ORDER BY 1,2
Login to post response