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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.