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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply