Post reply

MSFTE

  • June 2, 2008 at 7:04 am

    #191836

    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.

  • June 2, 2008 at 7:21 am

    #822907

    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.

  • June 2, 2008 at 7:35 am

    #822919

    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.

  • June 2, 2008 at 8:07 am

    #822948

    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.

  • June 2, 2008 at 8:39 am

    #822973

    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.

  • June 2, 2008 at 9:21 am

    #823015

    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

  • June 2, 2008 at 1:47 pm

    #823269

    Hi There,

    Thanks for the reply and help.

    Best Regards,

    Steve Wilson.

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

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