Notifies the Full-Text Search engine that the text_events table has been modified.
sp_text_notify [{true | false}] [, server_name]
– causes the procedure to run synchronously.
– causes the procedure to run asynchronously.
– is the name of the Full-Text Search engine you are notifying.
sp_text_notify true
You must run sp_text_notify after you issue sp_refresh_text_index to inform the Full-Text Search engine that the source tables have been modified.
If you do not specify true or false, sp_text_notify runs synchronously.
If no server name is specified, all Full-Text Search engines are notified.
Can’t run sp_text_notify from within a transaction
Notification failed, server = ’server_name’
Server name ’server_name’ does not exist in sysservers
The parameter value ’value’ is invalid
Any user can execute sp_text_notify.
