views:

15

answers:

0

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.