sp_text_online

Description

Makes a database available for full-text searches to Adaptive Server.

Syntax

sp_text_online [server_name], [database_name]

Parameters

server_name: is the name of the Enhanced Full-Text Search engine.

database_name: is the name of the database that you are bringing online.

Examples

Example 1

sp_text_online @database_name = pubs2

Makes the pubs2 database available for full-text searches using the Enhanced Full-Text Search engine.

Usage

If a database is not specified, all databases are brought online for full-text searches.
If a server name is not specified, all Enhanced Full-Text Search engines listed in the vesaux table are notified.
With the Enhanced Full-Text Search engine, databases are brought online automatically if the auto_online configuration parameter is set to 1.

Messages

All Databases using text indexes are now online
Databases containing text indexes on server ‘database_names’ are now online.
Server name server_name is now online.
Server name ‘server_name’ does not exist in sysservers.
The parameter value ‘value’ is invalid.
The specified database does not exist.
vs_online failed for server ‘server_name.’

Permissions

Any user can execute sp_text_online.