March 8, 2010 at 3:51 pm
Hi,
I'm trying to enable full text search on a database using SQL Server Management Express. I have enabled full text searching on the database, created a full text index on a table with a unique key and now trying to perform a full text find. However, when I do a find, nothing is returned.
I noticed that for my table, in the Full Text Index window, the Crawl Completed Field is set to No, although it's been more than an hour since the start of the current crawl. Is this the reason that my finds do not return anything? Also, my table just contains two rows, how long does it usually take for the crawl to complete.
This is my first time trying this out, so if anyone could help me out it would be much appreciated.
March 8, 2010 at 7:41 pm
Your crawl is probably still running, how long it takes depends on how much data it has to cover. I am no expert on FTS, but I have had more than one colleague have one of these take a week or more, and then afterwards discover that it was actually indexing a lot more data than they had intended it to.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2010 at 3:47 pm
Thanks for your reply Barry. After waiting for one more day, I ran out of patience and started using a local database server. Things seem to be working fine on this database, with the crawl finishing almost instantaneously and I am able to query full text searches.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply