Post reply

Sql full text 2008 index not populating

  • May 28, 2010 at 9:40 am

    #223195

    i configured full text index on a varchar column, but its not getting populated

    iam using sp2 windows 2003 server, with sql server 2008 web edition

    iam getting the error pasting below

    A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is cvsearch (id: 13); catalog name is cvs (id: 7); table name candidatesRegistration (id: 1138103095). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • May 28, 2010 at 10:47 am

    #1174063

    i found the solution for it, and iam posting it so it wud be useful for others

    go into sql server configuration manager

    just run the sql full text filter data dameon and the mss sql server in the same login

    i.e local system

    by default ful text runs on local service, change it local system it works

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply