Acknowledging Notifications

To acknowledge notifications using SQL SDK, the sp_sql_acknowledge_nofications procedure must be used.

declare @now t_datetime_value

set @now = getdate ()

exec sp_sql_acknowledge_notifications

@user_id = 6,

@time_acknowledged = @now,

@notification_ids_query =

'SELECT row_id FROM ea_notifications'

The @notification_ids_query parameter must be a syntactically correct SQL query whose result is one column of notification ID’s.