Jonas Stawski

Everything .NET and More

Enable Full-Text Indexing for a Database on SQL Server 2005

I needed to create a full-text index on a column, but I was unable to do so because of the following error: "Creation of the full-text index is not avaiable. Database is not enabled to allow for full-text indexing." After many hours of searching I found that Full-Text indexing is on by default. Well, not my case. I also found other suggestions of enabling them through the user interface, but I just couldn't find the option. After searching for a while, I found the query for enabling the feature:

EXEC sp_fulltext_database 'enable'

Of course you need to have the desired DB selected or just use a use statement in front of this one. Then to check if the operation worked you can execute:

SELECT DATABASEPROPERTY('DBName', 'IsFullTextEnabled');

A 1 means on, 0 means off.

Happy Programming!

Comments (11) -

KAPIL MAHERSHI
KAPIL MAHERSHI

THROUGH MANAGEMENT STUDIO WE CAN ALSO DO IT. RIGHT CLICK ON DATABASE --->FILE , AND CHECK THE FULL TEXT INDEXING

Reply

Birger Jansen
Birger Jansen

An old post, but it helped me... I couldn't figure out why I could not enable indexing on a specific table. Turns out full text indexing was not enabled for this database and your tip fixed this for me!

Reply

@Birger

I'm glad I could help

Reply

Thanks for this. Full text indexing was off for me too. The help is rubbish in telling you how to enable it. This post is perfect. Thank you for your help

Reply

This is just awsome!!
Thanks for the knowlegde

Reply

Mukesh Rawat
Mukesh Rawat

Thanks Man,it's awesome

Reply

thanks a lot friend

Reply

Very helpful, I needed the script to do this for a database that gets copied over every night. Options in boxes don't cut it when you want to automate!

Reply

Thanks a lot man

Reply

Thanks

Reply

Rajan Shrestha (Nepal)
Rajan Shrestha (Nepal)

Thanks a lot

Reply

Add comment

biuquote
Loading