Documenting Full-Text Indexes

Published Mar 23 2019 11:22 AM 132 Views
First published on TECHNET on Dec 17, 2009

Top-notch security requires a complete set of documentation to help DBAs remain aware of what they're responsible for, and help a new DBA become aware.

Recently, I was asked how to determine the complete list of full-text indexes on an instance, and couldn't find simple report, so I wrote the attached script to produce a list. The comments at the top of the script also include a query to check the progress of the 'population' process for full-text indexes, since that also doesn't have a handy report available.

List Full-Text Indexes.sql

Version history
Last update:
‎Mar 23 2019 11:22 AM
Updated by: