change default path of Full Text Search

  • 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

  • [@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.

  • 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

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

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