Full Text Indexing

Discussion in 'Databases' started by jordanbrock, Aug 10, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. jordanbrock

    jordanbrock

    As I understand it, Full Text searching is not enabled on DASP servers. Is this correct? Is there any chance of having it activated for a database?

    If not, what are the technical reasons behind not activating the service?
     
    jordanbrock, Aug 10, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    full text search is enabled on our server.

    you can configure it using query analyser. you cannot configure it using enterprise manager because you have to login as sa to do that.


    quote:Originally posted by jordanbrock

    As I understand it, Full Text searching is not enabled on DASP servers. Is this correct? Is there any chance of having it activated for a database?

    If not, what are the technical reasons behind not activating the service?
    </blockquote id="quote"></font id="quote">

    B.

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    Bruce, Aug 10, 2004
    #2
  3. pjoyce

    pjoyce

    pjoyce, Aug 18, 2004
    #3
  4. wtecapeann

    wtecapeann

    How do you go about doing this? I get lost when I try to figure it out.
     
    wtecapeann, Aug 18, 2004
    #4
  5. Bruce

    Bruce DiscountASP.NET Staff

    You'll have to set up the fulltext index using transact SQL via Query analyer.

    quote:Originally posted by wtecapeann

    How do you go about doing this? I get lost when I try to figure it out.
    </blockquote id="quote"></font id="quote">

    B.

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    Bruce, Aug 18, 2004
    #5
  6. wtecapeann

    wtecapeann

    Nevermind.. got pass that last step. Now I get confused when I am adding a table what is the 'unique_index_name' have to be and what is it for?
     
    wtecapeann, Aug 19, 2004
    #6
  7. wtecapeann

    wtecapeann

    nevermind i got it.. don't you hate when you don't read the directions right?
     
    wtecapeann, Aug 19, 2004
    #7
  8. Bruce

    Bruce DiscountASP.NET Staff

    Very strange.

    It could be the SQL server is low on disk space?? i'll check w/ the admin.


    quote:Originally posted by wtecapeann

    Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_catalog, Line 65
    Execution of a full-text operation failed. Unable to add a new catalog because of insufficient disk resources. Either free additional disk space or specify a different location for the catalog's files.



    I get that message when i do the sp_fulltext_catalog create step...
    </blockquote id="quote"></font id="quote">

    B.

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    Bruce, Aug 19, 2004
    #8
  9. wtecapeann

    wtecapeann

    Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_catalog, Line 65
    Execution of a full-text operation failed. Unable to add a new catalog because of insufficient disk resources. Either free additional disk space or specify a different location for the catalog's files.



    I get that message when i do the sp_fulltext_catalog create step...
     
    wtecapeann, Aug 19, 2004
    #9
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page