Ed,
You can use the following system stored procedures to determine what tables
are FT Indexed:
sp_help_fulltext_tables
You can also use the following metadata function to gather more FT info:
select
ObjectProperty(object_id(N'<table_name>'),N'TableHasActiveFulltextIndex')
select
objectproperty(object_id(N'<table_name>'),N'TableFulltextChangeTrackingOn')
select
objectproperty(object_id(N'<table_name>'),N'TableFullTextBackgroundUpdateInd
exOn')
select
objectproperty(object_id(N'<table_name>'),N'TableFullTextPopulateStatus')
Regards,
John
> Hi,
> I have a database that has about 100 tables. How can I find out which
> tables are full-text indexed?
> Thanks
>
> Ed