The Help for 126.96.36.1996 says that "When the client and server are both on the same computer, an empty string is returned" but that's not completely correct.
When the client is an EVENT, it returns 'NA'. Does that mean 'Not Applicable'?
Likely answer: "Gosh, what do you think, Breck?" <g>
And here is another stupid question: Does it return 'NA' for SERVICE connections as well? ( I don't have any of those that last long enough to see :)
SELECT * FROM sa_conn_properties() WHERE PropName = 'NodeAddress'; Number,PropNum,PropName,PropDescription,Value 1000000107,193,'NodeAddress','Client node address','NA' 1000000021,193,'NodeAddress','Client node address','NA' 177,193,'NodeAddress','Client node address',''
asked 26 Feb '10, 09:14
I can confirm that result for 188.8.131.526, and it's the same with 184.108.40.20686. And even for good old 220.127.116.1141 sa_conn_info() shows NA for an event's connection. Looks like it's always been there. So that might be the right time to request a documentation update (I don't have to point to to DCX, I suppose).
answered 26 Feb '10, 13:18