Enabling Full Text Search

  • i run a job portal

    i want to enable full text search for a particular column

    iam using sql server 2005

    coumn name is "jobdescription" its type is ntext

     

    i want to enable that column for full text search how can i do that, iam having very limited tools, i cannot connect using enterprise manager

    all i can do that is via querys

    any ideas???

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

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

  • can any one tell me atleast 2,3 queries atleast to get started.

    iam trying queries , it says you dont have permission to set full text index.

    i will need some correct queries so that i can argue with the hosting services.

    if my queries are wrong , then that wud be a problem

     

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

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

  • Have a look in Books online. There's a section on full text search.

    Full-Text Search Concepts (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/db3747e0-db12-4c69-9d81-b5011984eb3a.htm) should get you started.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • thank you gila, but my hosting co. now says there sql server dont support full text search

    damn what a waste of time

     

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

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

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

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