Bringing the Database Online for Full-Text Searches

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.