Please help - Named instances and full-text search

14 Mar 2007 3:53 PM

Derek

I asked this last week and no one replied :-(

i have a sql server 2000 default instance and i'm planning on adding
a sql server 2005 named
instance to the server. both will be using full text search. i
assume that each
instance should be assigned separate directories for their full text
catalog files?

14 Mar 2007 7:01 PM

John Bell

Hi Derek

"Derek" wrote:

> I asked this last week and no one replied :-(
>
> i have a sql server 2000 default instance and i'm planning on adding
> a sql server 2005 named
> instance to the server. both will be using full text search. i
> assume that each
> instance should be assigned separate directories for their full text
> catalog files?
>

The location for the FTS catalogs can be specified using the ON PATH
parameter of the CREATE FULLTEXT CATALOG command
http://msdn2.microsoft.com/en-gb/library/ms189520.aspx

or by us filling in the Catalog location in the dialog presented on SSMS
http://msdn2.microsoft.com/en-us/library/ms183531.aspx

Each instance has it's own FTS service therefore they can be configured
separately.
http://msdn2.microsoft.com/en-us/library/ms142490.aspx
and (I believe) there is an option to specify the default directory during
setup.

John