I am using SQL Dependency to register notification with SQL server. I have multiple tables for firing notifications after update. I got fired notification by SQL server after update, but, i could not identify which table is updated after got notification from SQL server.
Actually , SQL dependency have OnChangeEventHandler to handle single event at one time. How can i use this event handler for register notification for updating multiple tables and fire different notifications for different table.