How to enable full-text index in Sql Server 2008 table

Not sure what is happening with this, but here is my question. I have a Sql Server 2008 database that I need for full-text indexing / search, but when I try to tune my indexes in a table, I get the following:

alt text http://docs.google.com/a/delorenzodesign.com/File?id=dgr4q2dh_25sq4dnxd9_b

I tried to run this stored procedure in my database and successfully:

EXEC sp_fulltext_database @action = 'enable'

But I still get the above window, and my full-text searches do not return any results when they should.

What am I missing?

+3
source share
3 answers

" " . , , , " ". :

( , )...

, FDHOST (MSSQLFDLauncher), , , ...

, . , .: D

+2

, SQL Server SQL Server 2008. . SQL Management Studio, :

use [your_database_name]

CREATE FULLTEXT CATALOG ftCatalog AS DEFAULT;
GO

EXEC [your_database_name].[dbo].[sp_fulltext_database] @action = 'enable'
GO

. Management Studio, .

+3

Source: https://habr.com/ru/post/1706605/


All Articles