Notifies the Enhanced 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 Enhanced 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 Enhanced 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 Enhanced 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.
