Displays information about databases or text indexes that are currently online.
sp_show_text_online server_name [,{INDEXES | DATABASES} ]
– is the name of the 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 Full-Text Search engine.
exec sp_show_text_online KRAZYKAT, DATABASES
Displays all databases that are currently online in the KRAZYKAT Full-Text Search engine.
sp_show_text_online issues a remote procedure call (RPC) to the 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 DATABASES
Any user can execute sp_show_text_online.
