Post reply

Use Full-text indexing database property

  • July 13, 2006 at 10:17 am

    #173374

    Hello Everyone,

    I noticed, on SQL Server 2005, that this property is set to ON by default.

    Was it the case on SQL Server 2000? Or was it manage differently?

    Does it have an impact on performances?

    Since we are not using full-text indexing should we set it OFF?

    Not sure to understand the default value for this property...

    Regards,

    Carl

  • July 17, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 17, 2006 at 9:20 am

    #649588

    To be more precise : You can see it on the properties windows for the database (for the files). Or you can query it like this:

    select

    DATABASEPROPERTY ( '<db_name>' , 'IsFulltextEnabled' )

    Regards,

    Carl

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

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