Your company Web site includes a page that customers use to send feedback about the company and its
products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named
Feedback.
You need to implement full-text searching so that you can run reports on the comments.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Create a nonclustered index on the Comments column.
B.
Execute the USE Master Transact-SQL statement.
C.
Create a full-text catalog.
D.
Create a full-text index on the Comments column.