Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

is the server using full text

is there a setting that will tell if the server is using full text features, right now and implemented in any database?

thanks
0
anushahanna
Asked:
anushahanna
  • 2
  • 2
2 Solutions
 
CboudrozCommented:
This work for SQL 2005

IF (FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')=1) 
BEGIN
	print 'INSTALLED' 
END 
ELSE 
BEGIN 
	print 'NOT INSTALLED'
END

Open in new window

0
 
anushahannaAuthor Commented:
thanks Cboudroz-

the 'INSTALLED' part if of the original install?

how can we know if it is indeed being used for any columns/data in the databases?
0
 
CboudrozCommented:
You need to used system view.

sys.fulltext_catalogs
sys.fulltext_index_columns
sys.fulltext_indexes
sys.fulltext_document_types
sys.fulltext_index_catalog_usages
sys.fulltext_languages
0
 
anushahannaAuthor Commented:
Thanks Cboudroz.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now