Makes a database available for full-text searches to Adaptive Server.
sp_text_online [server_name], [database_name]
– is the name of the Full-Text Search engine.
– is the name of the database that you are bringing online.
sp_text_online @database_name = pubs2
Makes the pubs2 database available for full-text searches using the Full-Text Search engine.
If a database is not specified, all databases are brought online for full-text searches.
If a server name is not specified, all 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.
