sp_show_text_online

Description

Displays information about databases or text indexes that are currently online.

Syntax

sp_show_text_online server_name [,{INDEXES | DATABASES} ]

Parameters

server_name

– is the name of the Full-Text Search engine to which the request is sent.

INDEXES | DATABASES

– specifies whether the request should contain data about online indexes or online databases. The default is INDEXES.

Examples

Example 1

exec sp_show_text_online KRAZYKAT

Displays all indexes that are currently online in the KRAZYKAT Full-Text Search engine.

Example 2

exec sp_show_text_online KRAZYKAT, DATABASES

Displays all databases that are currently online in the KRAZYKAT Full-Text Search engine.

Usage

Messages

Permissions

Any user can execute sp_show_text_online.

See also

sp_text_online