locked
How to detect if full text indexing feature is installed in SQL Server 2008 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    hi everyone,
                       i installed sql server 2008. One of my developer wants full text indexing feature to be installed in the server. i think i installed all the features. i want to know the full text indexing is installed in the system and i want to know how to install the feature in the existing sql sever which is installed in the server machine(64-bit) and sql server 2008 (64-bit). consider me as beginner for SQL server 2008  
    Wednesday, November 18, 2009 11:57 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    select

     

    serverproperty('isfulltextinstalled')

    This will return a 1 if it is.

    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Proposed as answer by Hilary CotterMVP Thursday, November 19, 2009 12:03 PM
    • Marked as answer by KJian_ Monday, November 30, 2009 9:44 AM
    Wednesday, November 18, 2009 4:43 PM