2012年3月21日星期三

Full Text Search

Hi,
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.
Thanks
SmithAnything show up in the SQL Server errorlog? Also, did you apply all the service packs so the full Text Search executables are at the same version as the rest of your SQL Server?|||thanks for the reply
no nothing is shown in the event viewer. yes the service packs are the same..
smith|||How about SQL Server's errorlog?|||no help in errorlog too..|||Hi
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??

Thanks
Smith|||In SQL Server 2005 you can have multiple catalog for one database but each catalog can not contain more than one database.sql

没有评论:

发表评论