Search code examples
sql-server-2008full-text-indexingsystem-views

Missing Full Text Index System View In Sql Server 2008


I've been reading about the system view: sys.dm_fts_index_keywords_by_document on msdn but can't find the view in my 2008 database. Anyone know if it should be there by default?


Solution

  • It's a TVF not a View.

    If you mean you can't see it in Object Explorer look in the master database under Programmability -> Functions -> System Functions -> Table Valued Functions