sql server - Unable to set full-text index to 'active' in table-designer -
in sql server 2008 r2 management studio, have set database full-text indexed , ran command
exec sp_fulltext_database 'enable'
along creating catalog. when open table design mode, , right click primary key
, click full-text indexes
in context menu, add columns under 'general' section, when go set active = yes, it's grayed out.
how can change this? here screen-shot of it's looking like.
for reason can't enable or disable full text index screen. instead have right-click table in object explorer, choose full-text index > enable full-text index.
Comments
Post a Comment