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