With the Enhanced Full-Text Search engine, the database is automatically brought online when the auto_online configuration parameter is set to 1.
When you bring a database online, the Full-Text Search engine initializes the internal Verity structures and confirms that the Verity collections exist.
Use the sp_text_online system procedure to bring a database online for full-text searches if it is not automatically brought online. For example, to bring the pubs2 database online before issuing full-text searches on the blurbs table in a Full-Text Search engine named KRAZYKAT, enter:
sp_text_online KRAZYKAT, pubs2
This message appears:
Database ‘pubs2’ is now online
The pubs2 database is now available for performing full-text searches.
See sp_text_online for more information.