ASP.NET, SQL Server, WPF, C#, VB.NET

Query Notifications and Event Notification can hook into the Service Broker  
  
internals. They call directly our code, w/o going through the language API  
  
(e.g. there is no BEGIN DIALOG or SEND statement issued). You can still see  
  
though the Broker/Broker Conversation events from these internal calls, if  
  
you enable them in the Profiler.  
  
BTW the CREATE SERVICE/CREATE QUEUE etc you see in the profiler are the  
  
Query Notification statements, but the SqlDependency functionality. If you  
  
get to that level of detail, they are actually different components.  
  
--  
  
This posting is provided "AS IS" with no warranties, and confers no rights.  
  
HTH,  
  
~ Remus Rusanu  
  
SQL Service Broker  
  
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx  
  
"Leila" <Leilas@hotpop.com> wrote in message  
  
news:u9TxR5HRGHA.5108@TK2MSFTNGP09.phx.gbl...

Hi,  
  
I used profiler to trace my form which uses sqldependency to receive query  
  
notifications. I think I have understood how SQL Server creates the required  
  
services and queues, but when I update the table, I don't see any SEND  
  
command in profiler but my grid works well! How sending a message is  
  
performed for query  
  
notification?  
  
Thanks in advance,  
  
Leila

Thanks Remus :-)  
  
"Remus Rusanu [MSFT]" <Remus.Rusanu.NoSpam@microsoft.com.nowhere.moon> wrote  
  
in message news:ucT0QWIRGHA.256@TK2MSFTNGP14.phx.gbl...