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 2000 Forums
 SQL Server Administration (2000)
 Full text search indexing problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-11 : 08:42:07
Avish writes "Hi

I have SQL Server 7 Enterprise installed on Windows 2000 Advanced sever.

One of my tables contains about 7 million records and users need to search a text field. The problem is that the search times out!
I installed Full text search and created a catalog but cannot define a full text search on the table.The message "The Selected Table has no unique single column index" appears. Why am I getting this message?

Is full text searching my only option? What else can you suggest?


Thanks for all your Help
Avish"
   

- Advertisement -