sp_text_online

Description

Makes a database available for full-text searches to Adaptive Server.

Syntax

sp_text_online [server_name], [database_name]

Parameters

server_name

– is the name of the Full-Text Search engine.

database_name

– is the name of the database that you are bringing online.

Examples

Example 1

sp_text_online @database_name = pubs2

Makes the pubs2 database available for full-text searches using the Full-Text Search engine.

Usage

Messages

Permissions

Any user can execute sp_text_online.