Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Query Notification SELECT Query Expand / Collapse
Author
Message
Posted Saturday, November 24, 2012 12:57 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:39 PM
Points: 90, Visits: 365
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
Post #1388283
Posted Sunday, November 25, 2012 9:01 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:39 PM
Points: 90, Visits: 365
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.
Post #1388431
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse