Displays information about databases or text indexes that are currently online.
sp_show_text_online server_name [,{INDEXES | DATABASES} ]
is the name of the Enhanced Full-Text Search engine to which the request is sent.
specifies whether the request should contain data about online indexes or online databases. The default is INDEXES.
exec sp_show_text_online KRAZYKAT
Displays all indexes that are currently online in the KRAZYKAT Enhanced Full-Text Search engine.
exec sp_show_text_online KRAZYKAT, DATABASES
Displays all databases that are currently online in the KRAZYKAT Enhanced Full-Text Search engine.
sp_show_text_online issues a remote procedure call to the Enhanced Full-Text Search engine to retrieve information about the indexes or the databases that are currently online.
If the results of this procedure do not list a database, use sp_text_online to bring the desired database online.
sp_show_text_online failed for server server_name.
The parameter value ‘value’ is invalid.
The RPC sent to the server returned a failure return code.
The second parameter must be INDEXES or DATABASE.
Any user can execute sp_show_text_online.
