Step 5. Bring the Database Online for a Full-Text Search

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

sp_text_online MYTXTSVR, movies

NoteOmit this step if you have Enhanced Full-Text Search engine and your auto_online configuration parameter is set to “1”.

See sp_text_online for more information.