Full-Text Problem - SQL 2008 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Full-Text Problem - SQL 2008

Author

Topic

Westside
Starting Member

9 Posts

Posted - 2010-06-22 : 01:02:56

Hi,

I'm using SQL 2008

I'm trying to create a full-text index on a table and populate it but for some reason it doesn't seem to contain any data.

I ran this SQL:

SELECT *
FROM sys.dm_fts_index_keywords( DB_ID('mydb'), OBJECT_ID('Indexed_Table') )

Steps I'm taking via SSMS

1. Right Click Table, and Define Full Text Index
2. Choose Unique Index
3. Select table columns to be eligible for full-text queries
4. Create Full-Text Catalog, give it a name
5. Now that its created, I clicked "Start Full Population" and it says success

For some reason thought I still don't get any results when I query the table or run :

SELECT *
FROM sys.dm_fts_index_keywords( DB_ID('mydb'), OBJECT_ID('Indexed_Table')

Any ideas why?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources