You administer a SQL Server 2008 instance and a SQL Server 2005 instance. Both
instances run on the same computer. The SQL Server 2008 instance contains a database
named WebApplicationDB that uses the Fulltext indexes.
Several records that include the word “root” are added to the WebApplicationDB database.
When the Fulltext index is queried for the word “root,” an empty resultset is returned.
You need to ensure that records that contain the word “root” are returned by the query.
What should you do?
A.
Rebuild the full-text index.
B.
Add the word “root” to the stop list.
C.
Add the word “root” to the thesaurus file.
D.
Stop and restart the MSFTESQL service.