Makes a database available for full-text searches to Adaptive Server.
sp_text_online [server_name], [database_name]
is the name of the Enhanced Full-Text Search engine.
is the name of the database that you are bringing online.
Makes the pubs2 database available for full-text searches using the Enhanced Full-Text Search engine:
sp_text_online @database_name = pubs2
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.
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.’
Any user can execute sp_text_online.
