Post reply

Full text index

  • August 14, 2007 at 11:17 pm

    #121037

    Hello everone, i m using Sql Server 2000, for the textual fields i used the FullText Index, but now i have one question regarding this, at the deployment time, i have to do any manual configuration for this, as when we add unique index or other ones and after this when we generate script these index saved in that file but what abt the FT Index, for deploying DB to client what configuration i have to made as when we run the script the Full text index also created on the field of the desired table? As FT index is not a part of SQL SERVER 2000, so plz help me what can i do.

    Thanx in Advance.

  • August 15, 2007 at 8:30 am

    #727052

    the full text catalog is not stored in the database, but actually separately on the server i believe.

    as a result, you need to deploy the database, and after restoring it or whatever, then add the full text catalog via Enterprise manager on the target server.

    BOl has a great info on how to set it up, so just document the actual steps you do in development to set it up, and repeat when you deploy it.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply