We have a windows 2003 server (standalone) running SQL server 2000. We need to enable full text search on the database available in it. We have already added full text search in the installation and the option is available but when we try to create a full text catalog on any of the databases, it crashes ie., doesnot respond and gives the typical 'report to microsoft window'. We need to restart the SQL server after the same. can someone help us out.
We had rebuild the SQL server and now we are able to do FTS on just a single database. When we try to create Full Text catalog on other databases the MSSearch service stops. When we restart it, mssql is stopped. Is it not possible to have FTS in more than one database??