MSFTE

  • Steve Wilson-461924

    Old Hand

    Points: 355

    Hi Guys,

    Can Someone tell me how to turn on "Microsoft SQL Server Free Text Search Engine"

    Thanks for your help.

    Best Regards,

    Steve Wilson.

  • tosscrosby

    SSCoach

    Points: 18045

    Check out:

    http://www.eggheadcafe.com/articles/20010422.asp

    http://msdn.microsoft.com/en-us/library/ms345119.aspx

    A wealth of information on Google!

    -- You can't be late until you show up.

  • Steve Wilson-461924

    Old Hand

    Points: 355

    Hi There,

    Thanks for the reply, I appreciate it.

    Your first Link is showing steps for Sql Server 2000. I need 2005 and the second link tells you about the benifits of Full text indexing.

    What I need to know are the specific steps to turn the Full text indexing engine on.

    Would you know how I do that.

    Thanks again for your help.

    Best Regards,

    Steve Wilson.

  • tosscrosby

    SSCoach

    Points: 18045

    Sorry, didn't catch that it was for SQL2K. Anyway, this site has a couple of articles (parts 1 and 2!) that should help:

    http://www.sitepoint.com/blogs/2006/11/12/sql-server-full-text-search-protips-part-1-setup/

    -- You can't be late until you show up.

  • Steve Wilson-461924

    Old Hand

    Points: 355

    Hi Terry,

    Thanks again for the reply. That helped a little further. When I run the query:

    exec sp_fulltext_database 'enable'

    Sql Server comes back with Full-Text Search is not installed. Does this mean I should reinstall SQL Server 2005?

    Best Regards,

    Steve Wilson.

  • GSquared

    SSC Guru

    Points: 260824

    You don't have to re-install. Use Control Pannel "Add/Remove Programs", click on "Change" on SQL Server 2005. You'll need to have your install disk in the drive when you do this. This way, you can add the feature, without having to reinstall service packs and updates to the features you already have installed.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Steve Wilson-461924

    Old Hand

    Points: 355

    Hi There,

    Thanks for the reply and help.

    Best Regards,

    Steve Wilson.

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

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