Post reply

setting up noixse words for a full text search

  • April 12, 2009 at 4:36 pm

    #130012

    I have a server which runs 2 databases, both the databases utilise the full text search facility, however with one one of the databases I want to add the word 'hotel' as a noise word but I don't want it to be a noise word for the other database, is there a way of achieving this?

    PS. sorry I spelt 'noise' wrong in the title

  • April 12, 2009 at 5:01 pm

    #976351

    As far i Know, in SQL2K5 when you change the noise word file this apply in entire sql server and all databases fulltext indexed runing on it, by instance.

    I dont study the fulltext structure in SQL2K8 yet, but what I have read above it seems this was changed.

    $hell your Experience !!![/url]

  • April 13, 2009 at 7:33 am

    #976589

    In SQL Server 2005, "Noise Words", also known as "Stop Words", are global to each instance. So to have a different noise word list for a database, you'll have to create another instance.

    In SQL Server 2008, the noise words have been moved from the file system into database tables. You can create multiple noise word lists, or use the system default, and reference the named noise word list when you create the full-text index.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

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

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