sp_text_notify

Description

Notifies the Full-Text Search engine that the text_events table has been modified.

Syntax

sp_text_notify [{true | false}] [, server_name]

Parameters

true

– causes the procedure to run synchronously.

false

– causes the procedure to run asynchronously.

server_name

– is the name of the Full-Text Search engine you are notifying.

Examples

Example 1

sp_text_notify true

Usage

Messages

Permissions

Any user can execute sp_text_notify.

See also

sp_refresh_text_index