Hi i am really new to full text searching, I have created a catalog using:
sp_fulltext_catalog 'textcatalog','create'
and now i want to add a table with:
sp_fulltext_table 'Product', 'create','textcatalog', 'ProductID'
where product is a table in my database and productID is the primary key to that table. The primary key cannot be null,
But i get an error:
'ProductID' is not a valid index to enforce a full-text search key. You must specify a unique, non-nullable, single-column index.
I have a feeling i have to create some sort of index but am not sure how!
Can any one point me in the right direction I am using SQL 2000
Thanks in advance
Tuppers!
Full Text Issues
Hot Topic
- File Connector w/ Execute Package Task Expression Bug?
- fetching a string containging character " ' " from Datatable
- Importing a SQL File from the Internet...
- Management Studio lists all databases
- What accounts for this performance difference?
- Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum)
- How do you process AS objects from the command-line?
- SQL Task - passing parameters
- FileSystem Deployment
- Temporary table vs. Table Valued function
SQL Server
- Changes in SP1 for SSRS 2005
- Custom Rendering Extension for HTML Fields
- SQL Server 2005 won't install
- Can not attach SQL Server 2005 Express database
- DSV and Cube do not match - generates Key Errors
- Tx replication works in 2000 but not in 2005?
- identity insert in "export data"
- RS 2005 - Evaluation Version
- Problem with query using SQL Server 2005 September CTP
- Why doesn't DTSHost.exe exit when debugging is finished?
Full Text Issues
ZahranyM
Tuppers
Gette
hi figured it out! i hadnt created the primary key on the table to make the index on!! Silly me!!
Thanks for looking!
Tuppers!!
K.Paing
I indexed the primary key and the field for full-text search but still getting the same error message. Please help out. Thanks.
blumonde