November 16, 2010 at 8:05 am
I want to use the functionality of CONTAINSTABLE function. I tried to create a full text index but it says "Creation of the full text index is not available. Database is not enabled to allow for full-text indexing."
How do I enable it?
We are looking to do some searches on a table, we came up with an asp solution but we wanted something in sql. Rather then trying to translate the asp function into sql i found the CONTAINSTABLE function which i believe does the same thing. We are completely new to indexing. Any help would be great.
November 16, 2010 at 8:20 am
right click on the database, click on properties then click on files and check the box 'enable full-text indexing'
November 16, 2010 at 8:25 am
its checked and grayed out
November 16, 2010 at 3:42 pm
Have you verified the service is running? SQL Server FullText Serach (MSSQLSERVER) or whatever instance name you are working with
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 17, 2010 at 7:08 am
How do i check?
November 17, 2010 at 7:12 am
Bring up Windows Services on the SQL Server - Start | Administrative Tools (which may be in Control Panel) | Services, scroll through the list until you find "SQL Server FullText Search (MSSQLSERVER)"
Right-click on "SQL Server FullText Search (MSSQLSERVER)" and select Properties.
Set the "Startup type:" to Automatic and click on "Start"
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy