Welcome to Sign in | Help
in Search

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

Last post 01-18-2006, 3:55 PM by xmldeveloper. 0 replies.
Sort Posts: Previous Next
  •  01-18-2006, 3:55 PM 1

    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 as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems