Full Text default location | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Full Text default location

Hi, how can I change the default path for the full text catalog location? I think it’s a registry update but I can’t find it. Any ideas? I used to be able to modify the sysfulltextcatalog table and update the "Path" column but can’t with 2005. thanks
You can do it in two different ways…
One is regedit…but becareful when you modify the registry…
HKEY_LOCAL_MACHINE/Software/Microsoft/Microsoft SQL Server/MSSQL.x/MSSQLServer/FullTextDefaultPath – specify path Second one you can specify the path when you create the catolog…check BOL for details… CREATE FULLTEXT CATALOG catalog_name [IN PATH ‘rootpath’] MohammedU.
Moderator
SQL-Server-Performance.com
]]>