Friday, February 24, 2012

fulltext search in sql express 2005

I had problem when change database from sqlserver 2000 to sql express 2005.

The fulltext index does not create automatically.

Example:

i use sqldatasource to insert new name to my table.

and then i find it by query like this : select count(*) from mytable where contains(mycol,'newname')

the result is 0

but if i run query to start full index : exec sp_fulltext_catalog 'myfulltext','start_full' and run query

select count(*) from mytable where contains(mycol,'newname')

again. The result is 1.

So i alway run exec sp_fulltext_catalog 'myfulltext','start_full' after insert or update, delete to create fulltext index. When i use sql server 2000 , i didn't need do that, it automatic.

Pls help me !!! how to make fulltext index create auto in sql express 2005 .


You need to set "Change Tracking" to automatic.

The index update will not be instantaneous, but it will be automatic.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=680500&SiteID=1

http://technet.microsoft.com/en-us/library/ms187317.aspx

No comments:

Post a Comment