Home Other Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database
07.09.2010
Main Menu
Programming
.NET Controls
Operating System
Databases
Articles
Add to: Digg Add to: Del.icoi.us Add to: Reddit Add to: StumbleUpon Add to: Slashdot Add to: Yahoo Add to: Technorati Add to: Google
Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database

You are getting an error "Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database" while perform a full text search against a database.

Try to execute this command to enable full text search for your database.

USE Your_DB_Name
EXEC sp_fulltext_database 'enable'

 



Comments (0)
Write comment
Your Contact Details:
Comment:
[b] [i] [u] [url] [quote] [code] [img]   
:D:angry::angry-red::evil::idea::love::x:no-comments::ooo::pirate::?::(
:sleep::););)):0
Security
Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."