I am attempting to enable Full Text Indexing on the sample Pubs database in
SQL Server 2005 express. I right click on the pubs database and select the
files tab. The 'use full text indexing' checkbox is greyed out, or
unavailable. I have full owner access rights, but there may be some twist
to the security setup that I don't understand.

thanks for any advice.

There was a discussion about this recently. Express doesn't seem to come with FT, while Express with
Advanced Services comes with FT. But SSMS doesn't understand the later, so this is why you don't see
it in the UI. If you have Express with Advanced Services, use commands instead (like CREATE FULLTEXT
CATALOG etc).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Paul" <paul_NoSpam@maywoodconsulting.com> wrote in message
news:06C719B4-15C9-44AF-B602-E7C82C09F320@microsoft.com...
>I am attempting to enable Full Text Indexing on the sample Pubs database in SQL Server 2005
>express. I right click on the pubs database and select the files tab. The 'use full text
>indexing' checkbox is greyed out, or unavailable. I have full owner access rights, but there may
>be some twist to the security setup that I don't understand.
>
> thanks for any advice.