Problem initializing full-text search


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Problem initializing full-text search

  1. #1
    Join Date
    Jan 2004
    Location
    Alexandria, VA
    Posts
    392

    Problem initializing full-text search

    I am trying to run "sp_fulltext_database 'enable'" to enable full-text search on a DB. I get the error message:

    "Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46
    Full-Text Search is not installed, or a full-text component cannot be loaded."

    Particulars:

    MS-SQL Server 2K (actually MSDE)
    OS: MS XP, sp1
    Indexing Service and MS-SQL Service both running as local system account
    Logged in as a local admin

    Any thoughts?

    Thanks...
    Bob Rouse
    Dimension Data

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    I don't think MSDE supports full-text search. For development, you may use SQL Server Developer Edition; for deployment, I believe you'll need the Enterprise or Workgroup Editions.
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Jan 2004
    Location
    Alexandria, VA
    Posts
    392
    Bummer... I suspected as much. Do you have a link to a page where MS says that explicitly (I couldn't find one)? We sell a lower end product (hence MSDE), and I want to be certain when we tell customers that if they want full-text retrieval, they need to upgrade to full-blown MS-SQL.

    Thanks,
    Bob Rouse
    Dimension Data

  4. #4
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center