Post reply

SQL Query Notification SELECT Query

  • November 24, 2012 at 12:57 am

    #285288

    Hi folks,

    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

  • November 25, 2012 at 9:01 pm

    #1562068

    Strange thing that has been observed using the same query. It works on my local host (SQL 2008 R2) while it does not on dev environment (SQL Server 2005 Express).

    I compare the database options between these databases. The 2008 has the option

    SET HONOR_BROKER_PRIORITY OFF

    while 2005 does not.

    Hope someone can help.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply