Full Text Index type column is empty
Posted
by RemotecUk
on Stack Overflow
See other posts from Stack Overflow
or by RemotecUk
Published on 2010-03-08T12:00:45Z
Indexed on
2010/03/08
12:06 UTC
Read the original article
Hit count: 376
I am trying to create an index on a VarBinary(max) field in my SQL Server 2008 database.
The steps I am taking are as follows:
Table: dbo.Records
- Right click on table and select "Full Text Index"
- Then select "Define Index..."
- I choose the primary key which is the PK of my table (field name Id, type UniqueIndentifier).
- I then get the screen with the options Available Columns, Language for Word Breaker and Type Column
- I select my VarBinary(max) field called Chart as the Available Column by ticking the box.
- I select "English" as the Language for Word Breaker field.
Then... I try to select the Type Column but there are no entries in here. I cannot proceed by clicking "Next>" until this column is populated.
Why are there no entries in this column for selection and what should be in there?
Note 1: The VarBinary(max) field is linked to a file group if that makes any difference. Note 2: Also noticed that in the table designer I cannot set the full text option on that same field to "Yes" - its permanently stuck on "No".
Thanks.
© Stack Overflow or respective owner