I'm currently writing stored procedure which contains SELECT query supported by SQL Query Notification. What's strange is that when the query references multiple tables, it does not fire.
Just wanted to ask if there is a limit on the number of tables that I can JOIN for SQL Query Notification.
Hope someone can shed some light on this.
Thanks in advance