Welcome to Sign in | Help

How to check if full-text querying is enabled for a database ?

  •  01-18-2006, 3:55 PM

    How to check if full-text querying is enabled for a database ?

    Using DATABASEPROPERTY function and IsFullTextEnabled parameter.
    CODE:

    USE AdventureWorks;
    GO
    SELECT DATABASEPROPERTY('AdventureWorks', 'IsFullTextEnabled');
    GO
    

    REFERENCE: "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx
    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems