Cannot Rebuild full text catalog in SQL SERVER 2000

• fosco-515896

  SSChasing Mays

  Points: 614

  More actions

  December 5, 2007 at 5:19 am

  #122542

  Hi ,

  Can anyone help, am trying to Rebuild full text catalog in sql server 2000 Enterprise Manager, but its giving error message because its pointing to a different path T:drive, which need to be changed to S:drive.

  The database was attached from a server on the T:drive to another server on an S:drive, so it seems to be hardcoded on T, hence we cannot do rebuild the full text search, neither can it be deleted.

• fosco-515896

  SSChasing Mays

  Points: 614

  More actions

  December 5, 2007 at 9:54 am

  #757388

  Now fixed, we used the Stored Procedures below, executed them separately in query analyzer:

  **//Make sure you execute these scripts separately

  --1)

  sp_configure 'allow update', '1'

  RECONFIGURE WITH OVERRIDE

  --2)

  update sysfulltextcatalogs set path='S:\Text'

  --3)

  sp_configure 'allow update', '0'

  RECONFIGURE WITH OVERRIDE