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
LVL 6
anushahannaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
CboudrozConnect With a Mentor Commented:
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
 
CboudrozConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.