change default path of Full Text Search

• sqlrumble

  Default port

  Points: 1458

  More actions

  June 24, 2005 at 5:21 am

  #86658

  Hello,

  How can I change the default path of where all new Full Text Search Catalogs are stored.

  I can see from the MS Search Service the current default location, however I would like to change this.

  Thanks in Advance.

  SM

• Binnie Poonian

  Valued Member

  Points: 58

  More actions

  June 24, 2005 at 8:23 am

  #568283

  [@path =] 'root_directory'

  Is the root directory (not the complete physical path) for a create action. root_directory is nvarchar(100) and has a default value of NULL, which indicates to use the default location specified at setup. (This is the Ftdata subdirectory in the Mssql7 directory; for example, C:\Mssql7\Ftdata.). The specified root directory must exist, reside on a drive on the same computer; consist of more than just the drive letter, and cannot be a relative path. Network drives, removable drives, floppy disks, and UNC paths are not supported. Full-text catalogs must be created on a local hard drive associated with the machine on which SQL Server is running.

  @path is valid only when action is create. For actions other than create (stop, rebuild, and so on), @path must be NULL or omitted.

• sqlrumble

  Default port

  Points: 1458

  More actions

  June 24, 2005 at 9:00 am

  #568291

  Hello,

  I would like to change the path to be a default for every catalogue that is created.

  I presume the command that you have illustrated is refering to a funcation when a catalugue is created.

  Thanks