dbTalk Databases Forums  

Sql Server Full Text Index

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Sql Server Full Text Index in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Piero 'Giops' Giorgi
 
Posts: n/a

Default Sql Server Full Text Index - 07-18-2007 , 11:07 AM






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)


Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Sql Server Full Text Index - 07-18-2007 , 04:45 PM






Piero 'Giops' Giorgi (giorgi.piero (AT) gmail (DOT) com) writes:
Quote:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.