Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2007
    Posts
    4

    Unanswered: 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
    Smith

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Anything 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?

  3. #3
    Join Date
    Oct 2007
    Posts
    4
    thanks for the reply
    no nothing is shown in the event viewer. yes the service packs are the same..
    smith

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    How about SQL Server's errorlog?

  5. #5
    Join Date
    Oct 2007
    Posts
    4
    no help in errorlog too..

  6. #6
    Join Date
    Oct 2007
    Posts
    4
    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

  7. #7
    Join Date
    Oct 2007
    Location
    Florida USA
    Posts
    2
    In SQL Server 2005 you can have multiple catalog for one database but each catalog can not contain more than one database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •