Use the xp_messenger extended stored procedure to notify applications or services about SQL Server events in the real-time mode. You can easy build much more sophisticated applications or services. Now, in awaiting some critical data or events an application does not need to query SQL Server repeatedly. The SQL Server will notify an application when the data came or event happend.