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:45 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:41 PM
Points: 95, Visits: 396
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 #1388282
Posted Saturday, November 24, 2012 12:58 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:41 PM
Points: 95, Visits: 396
Moved this thread to General Discussions: http://www.sqlservercentral.com/Forums/Topic1388283-149-1.aspx
Post #1388284
Posted Friday, November 30, 2012 10:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 30, 2012 10:14 PM
Points: 1, Visits: 11
Hi,

Yes, you can JOIN query try it now and implement on it.


Oracle DBA || Oracle DBA India
Post #1391621
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse