You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01 that has two RAID-5 arrays for storing data files. Certkiller -DB01 hosts a database named CK_Products that stores data on the products sold by Domain.com.
Domain.com wants to allow prospective customers search for information in the CK_Products database via a Web-based interface. The prospective customers will use key words and phrases to search the CK_Products database. You decide to implement a Full-Text Search on the database. You install the Full-Text Search component on Certkiller -DB01 and start the Microsoft Search service. You then create the required catalog and full-text index. You modify the full-text index by running the following Transact-SQL statement:
ALTER FULLTEXT INDEX ON CK_Products.Description
ADD (shortName)
WITH NO POPULATION
Later you discover that you cannot perform full-text queries against the shortName column. You need to ensure that full-text queries can be performed against the shortName column.
What should you do?