i'm trying to set up a full text search catalog on MS SQL2K and i am not getting very far. i've succeeded on our local development server but cannot get the catalog created on the remote server.
i'm doing the following connecting through query analyser:
EXEC sp_fulltext_database @action='Enable'
EXEC sp_fulltext_catalog @ftcat = 'CobhamFullText', @action='CREATE'
but this is where it falls over with the following message:
Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_catalog, Line 65
Execution of a full-text operation failed. The directory name is invalid.
as i say, this works fine on my local server and i can continue and create indexed and search merrily. remotely we have SQL installed on the C: drive and the data sits on D: - i have tried adding @path to the sproc but still no good.
any ideas? i'm sure it's a simple thing but it's doing my head in!