Posted by Erland Sommarskog on 07/18/07 21:45

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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How do I see the result of calling a stored procedure in VB6 ?
• Prev in forum: Re: Connecting to SQL Server 2000 via VB6 program on Vista
• Thread view: Re: Sql Server Full Text Index

[Reply to this message]