If you are wondering whether full text search is enabled on a database, all that you need to do is execute the following query against it: SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'). If 0 is returned then it is not enabled, if 1 is returned then it is enabled.