Sql Server Full Text Index

Hi!

I'm trying to set up a full text catalog for my criminal database, but
I'm running into some difficulties.

Example (Just to start)... WHY Do I keep getting this message???

Thanks!!!

TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot execute changes.
------------------------------
ADDITIONAL INFORMATION:
Create failed for FullTextCatalog 'ABSO_FullTC'.
(Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Full-Text Search is not enabled for the current database. Use
sp_fulltext_database to enable full-text search for the database. The
functionality to disable and enable full-text search for a database is
deprecated. Please change your application. (Microsoft SQL Server,
Error: 7616)

Re: Sql Server Full Text Index

Piero 'Giops' Giorgi (giorgi.piero@gmail.com) writes:
> I'm trying to set up a full text catalog for my criminal database, but
> I'm running into some difficulties.
>
> Example (Just to start)... WHY Do I keep getting this message???
>
> Thanks!!!
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
> Cannot execute changes.
> ------------------------------
> ADDITIONAL INFORMATION:
> Create failed for FullTextCatalog 'ABSO_FullTC'.
> (Microsoft.SqlServer.Smo)
> ------------------------------
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> ------------------------------
> Full-Text Search is not enabled for the current database. Use
> sp_fulltext_database to enable full-text search for the database. The
> functionality to disable and enable full-text search for a database is
> deprecated. Please change your application. (Microsoft SQL Server,
> Error: 7616)

Not that I know much about fulltext, but have you complied with the
error message and run sp_fulltext_database?

microsoft.public.sqlserver.fulltext may be better place to get answers
about full-text.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx