SQL Server Express and full-text search

[flynn]

The document located at:

http://msdn2.microsoft.com/en-us/library/ms142557(d=ide).aspx

 

has this note listed:

 

"In Microsoft SQL Server 2005, all databases are full-text enabled by default. "

 

But when I try this query:

 

select description
from item
where contains(description, '"model"')

 

I get this message:

Msg 7601, Level 16, State 2, Line 1
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'item' because it is not full-text indexed.

 

 

I am using SQL Server Express, so that might make a difference. Has anyone successfully used full-text search with SQL Server Express 2005?

 

I am trying to find out how to enable the search, but haven't had any luck so far.

 

Thanks for any help provided,

flynn

[FZelle]

You need the "new" Sql-Server express.

 

The old one didn't have Fulltextsearch.

With that Update you also get Reportingservices and the Managment Studio