What are all the Tables / Columns involved in Full-Text search

PandianS
Posted by PandianS under Sql Server category on | Points: 40 | Views : 2483
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

Comments or Responses

Posted by: Raja on: 12/1/2010 Level:Starter | Status: [Member] | Points: 10
Very informative and unique post. Good stuff.

Login to post response