Disabling FullText Search on Active/Passive Cluster?

• Keith Knox

  Mr or Mrs. 500

  Points: 588

  More actions

  March 4, 2008 at 12:16 pm

  #187280

  We are not using FullText Search in our db's. So, what's the best way to turn off FullText Search on our Cluster? Do I just take the resource offline and delete it?

  Or do I just leave even though it's not being used?

  Thanks.

• SanjayAttray

  SSChampion

  Points: 13157

  More actions

  March 4, 2008 at 12:27 pm

  #785144

  use databasename

  go

  exec sp_fulltext_database 'disable'

  SQL DBA.

• Keith Knox

  Mr or Mrs. 500

  Points: 588

  More actions

  March 4, 2008 at 12:33 pm

  #785153

  Is FullText Search enabled by default on each database?

  So, you're saying just disable it on the db's and leave the cluster resource alone?

  Is there a way to do it for about 50 db's instead of one at a time?

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  March 4, 2008 at 1:57 pm

  #785206

  You can remove the child feature via the command line - i.e. REMOVE=SQL_FullText. For more information refer to BOL:

  http://technet.microsoft.com/en-us/library/ms144259.aspx

  Tommy

  Follow @sqlscribe