CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • SQL Server Create failed for FullTextCatalog

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    188
  • Date Created
    Friday, August 31, 2012
  • Last Updated
    Friday, August 31, 2012
  • This Article Has been Viewed
    1949 times
  • Short Desc
    When creating a Full Text Catalog for your database, you may not have Full Text Indexing Enabled, if that is the case, you may get the Create failed for FullTextCatalog.
  • Details
    When in SQL Server Management Studio, if you do not have Full Text Indexing Enabled for your table, you will receive the following error:

     

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    Cannot execute changes.
    ------------------------------
    ADDITIONAL INFORMATION:

    Create failed for FullTextCatalog 'kbCatalog'. (Microsoft.SqlServer.Smo)

    For help, click«
    ------------------------------
    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)

    For help, click«
    ------------------------------
    BUTTONS:
    OK
    ------------------------------
  • Recreate Issue
    To recreate this issue:

    If [Full Text Indexing] is not [Enabled] for the Database, you will receive this error.
  • Resolve Issue
    To resolve this issue.

    With [SQL Server Management Studio] opened.
    Right click on the database name
    Choose [New Query]
    Paste this in (Replace the <DATABASE NAME> with your database name)
     
    SELECT DATABASEPROPERTYEX('<DATABASE NAME>','IsFullTextEnabled')

    If you get a [1] back, then you are good to go.
    If you get a [0] back, then run the following command:
     
    EXEC [<DATABASE NAME>].[dbo].[sp_fulltext_database] @action = 'enable'

    Once this succeeds, run the first command once more, and you should have a [1].

    To Create Your [Full Text Catalog]
    Expand the Database
    Expand [Storage]
    Right Click on [Full Text Catalogs]
    Choose [New Full-Text Catalog]
    [Full-text_catalog name] (Give a name, single word)
    Click [OK]

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles