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.
Displays all indexes that are currently online in the KRAZYKAT Enhanced Full-Text Search engine:
exec sp_show_text_online KRAZYKAT
Displays all databases that are currently online in the KRAZYKAT Enhanced Full-Text Search engine:
exec sp_show_text_online KRAZYKAT, DATABASES
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.
