Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Location
    SW England
    Posts
    102

    Unanswered: full text search error - catalogue does not exist

    Hi guys, I sent the following queries to my DB and they seem to work with success messages after each line but when I try to test it I get the message at the bottom. Any ideas? there's a good chance my test sql is all wrong!

    Code:
    sp_fulltext_database 'enable' 
    
    sp_fulltext_catalog 'Fulltextcatalog1','create' 
    
    sp_fulltext_table 'test','create','Fulltextcatalog1','PK_test'
    
    sp_fulltext_column 'test','text','add'
    
    sp_fulltext_table 'test','activate'
    
    sp_fulltext_table 'test','start_full'
    
    sp_fulltext_table test, 'Start_change_tracking' 
    
    sp_fulltext_table test, 'Start_background_updateindex'

    ---- now test it ---

    Code:
    SELECT * FROM test WHERE FREETEXT(*,'spotless')
    gets this result:
    Error -2147217900
    Execution of a full-text operation failed. The catalog does not exist or is currently unavailable. Please retry the action again later and if this symptom persists, contact the system administrator.

  2. #2
    Join Date
    Oct 2005
    Location
    SW England
    Posts
    102
    Just tried this (where my field name is 'text' and my table is called 'test') but get the same catalogue error
    Code:
    SELECT * FROM test WHERE CONTAINS(text,'spotless')

Posting Permissions

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