Hello,
I have a query about full-text search feature of MS SQL
Server 2000. According to MSDN - "The principal design
requirement for full-text indexing, querying, and
synchronization is the presence of a full-text unique key
column (or single-column primary key) on all tables that
are registered for full-text search".
Now my question is -
1) What is this index needed for?
2) In my database design, the table I want to create full-
text index on has a composite primary key spanning 3
columns. How can I do full-text search on a text field in
this table? I cannot change the database design now to create a single column primary key.
Thanks in advance,
- Abhi.
I have a query about full-text search feature of MS SQL
Server 2000. According to MSDN - "The principal design
requirement for full-text indexing, querying, and
synchronization is the presence of a full-text unique key
column (or single-column primary key) on all tables that
are registered for full-text search".
Now my question is -
1) What is this index needed for?
2) In my database design, the table I want to create full-
text index on has a composite primary key spanning 3
columns. How can I do full-text search on a text field in
this table? I cannot change the database design now to create a single column primary key.
Thanks in advance,
- Abhi.