Anyone know anything about MS SQL Server Full Text Search stuff?
We are running SQL Server 2000, and I have created a Full Text catalogue on a database, have indexed the appropriate tables/columns, and have fully populated the Full Text catalogue. All should be going well.
Every time I attempt to query the catalogue with something such as "select first_name, surname from user_details where contains(first_name,'chr*')", I get the following message:
Server: Msg 7619, Level 16, State 1, Line 1
Langauge database/cache file could not be found.
I have restarted the Full Text service, the MS Search service, deleted and recreated the catalogue, and as desperate attempt, have even rebooted the server, but all to no avail.
Can anyone suggest what the problem could be?
Many thanks
We are running SQL Server 2000, and I have created a Full Text catalogue on a database, have indexed the appropriate tables/columns, and have fully populated the Full Text catalogue. All should be going well.
Every time I attempt to query the catalogue with something such as "select first_name, surname from user_details where contains(first_name,'chr*')", I get the following message:
Server: Msg 7619, Level 16, State 1, Line 1
Langauge database/cache file could not be found.
I have restarted the Full Text service, the MS Search service, deleted and recreated the catalogue, and as desperate attempt, have even rebooted the server, but all to no avail.
Can anyone suggest what the problem could be?
Many thanks
