Below is the script I learned while in Seattle attending PASS conference. Some guys from Microsoft helped me to rebuild full text index on some SharePoint databases I manage. select * from sys.fulltext_catalogs sp_configure ‘show adv’,0 reconfigure — Get the fulltext catalog name to rebuild select object_name(object_id), * from sys.fulltext_indexes select * from docs where…