<div>
You have &quot;Allow nulls&quot; checked - making that field nullable and therefore not suitable to be an index.
</div>


You have "Allow nulls" checked - making that field nullable and therefore not suitable to be an index.

<div>
Thanks for the reply duttcom - In the management studio, when I click on Indexes, the new index option is still grayed out after removal of the allow nulls
</div>


Thanks for the reply duttcom - In the management studio, when I click on Indexes, the new index option is still grayed out after removal of the allow nulls

<div>
Sorry - didn't see your 2nd comment.
</div>


<div>
<div class="content wysiwyg-content">
I am trying to set up a full text search on a table in SQL Server 2008 R2. &nbsp;My table looks like this<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/07_w30/861768/Table.jpg" target="_blank" title="Table.jpg (11 KB)"><img alt="Table.jpg" class="file-block lazyload" style="max-width: 341px;" data-src="https://filedb.experts-exchange.com/incoming/2014/07_w30/861768/Table.jpg" /></a>According to what I have read I need to create a &quot;unique, single-column, non-nullable index&quot;. &nbsp;When I try to create the index on the FText field everything is grayed out so I cannot do it.<br />
<br />
How do I proceed?
</div>
</div>


Table.jpg

I am trying to set up a full text search on a table in SQL Server 2008 R2.  My table looks like this

According to what I have read I need to create a "unique, single-column, non-nullable index".  When I try to create the index on the FText field everything is grayed out so I cannot do it.

How do I proceed?

Indexing problem

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.