Wednesday, November 30, 2011

2 How to check fulltext search feature is installed on the SQL Server.

From SQL Server 2008, the fulltext index is always enable on the user database and can not be disable. However, to make it effective, we must create the fulltext index.

Also, the MSSQLFDLauncher service must be installed on the host. The service is instance specific. The actual executable is fdlauncher.exe.

We can user SERVERPROPERTY to determine whether the full text search feature is install for the SQL Server.

  1. select SERVERPROPERTY('IsFullTextInstalled')

image

2 comments:

  1. From
    Apkzm.com
    Aptoide Apk Download
    Appvn Apk Download
    Thank you for sharing valuable information. Thanks for providing a great informatic blog

    ReplyDelete
  2. OMEGA has been uk replica watches a world leader in advanced watch design since 1848. replica omega seamaster watches ver the years, the brand has been widely celebrated for their durability and precision. OMEGA has served as the official timekeepers of the Olympic Games for nearly a century. They also created the official watch of the space program and first watch to land on the moon. Buying an OMEGA watch is an excellent way to invest in a piece of history.

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates