If you have ever used a SqlDependency in .NET 2.0, have you ever inspected the object before you execute your command?
In the object is a property called Callback ID. When I am running both the .NET code and SQL Server on the same machine or same network, this is set up to traverse back through TCPIP.
“<MachineAddress>tcp://192.168.0.5:58343</MachineAddress>
<AuthType>None</AuthType>
<Key>a55f6539-5d30-4e67-b87a-a4e3ebb85131</Key>”
192.168.0.5 is the address of the client machine and 58343 is one of the ports that SqlDependency is pre-defined to use. This is using Beta2 bits and I expect that this will change when I load the next CTP onto my computer. But for now, it’s interesting to see.
I am now curious to see what the message looks like when it arrives in SQL Server’s clutches, before it strips out the query and sends it off to be processed.
www.acehaid.org
Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!