Step 5. Bringing the database online for a full-text search

To bring the movies database online for the Enhanced Full-Text Search engine named MYTXTSVR, enter:

sp_text_online MYTXTSVR, movies

Omit this step if you have auto_online set to “1”.

See sp_text_online for more information.