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 12»»

Classifier Functions Expand / Collapse
Author
Message
Posted Saturday, January 7, 2012 5:29 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:13 PM
Points: 33,100, Visits: 15,210
Comments posted to this topic are about the item Classifier Functions






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1231994
Posted Saturday, January 7, 2012 5:31 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:13 PM
Points: 989, Visits: 1,821
"the 'local_net_address' parameter is used to get the IP address of the client."

Yet from books online:

"Returns the IP address on the server that this connection targeted. Available only for connections that are using the TCP transport provider."

In other words, it returns the SERVER IP address, NOT the client IP address, which is returned by the option from the fourth option. Steve, I think you copied and pasted wrong.
Post #1231995
Posted Saturday, January 7, 2012 10:13 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:07 PM
Points: 11,194, Visits: 11,109
Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1232006
Posted Sunday, January 8, 2012 1:10 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:18 AM
Points: 8,574, Visits: 9,082
Good question, but I don't like the explanation - it doesn't return the client IP address, it returns the server's IP address to which the client connected.

Tom
Post #1232129
Posted Sunday, January 8, 2012 1:13 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:18 AM
Points: 8,574, Visits: 9,082
SQL Kiwi (1/7/2012)
Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.

The only reason I got this right is that only one of the four options had a valid parametername - all the others would have been uncrecognised so that null would be returned. Judging by the explanation, Steve ment to have client_net_address (but that wasn't an option).


Tom
Post #1232130
Posted Sunday, January 8, 2012 1:40 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:56 AM
Points: 5,575, Visits: 24,824
L' Eomot Inversé (1/8/2012)
SQL Kiwi (1/7/2012)
Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.

The only reason I got this right is that only one of the four options had a valid parametername - all the others would have been uncrecognised so that null would be returned. Judging by the explanation, Steve ment to have client_net_address (but that wasn't an option).


+1

And the results are showing:

Correct answers: 31% (4)
Incorrect answers: 69% (9)
Total attempts: 13



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1232133
Posted Sunday, January 8, 2012 2:21 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 21,342, Visits: 15,017
L' Eomot Inversé (1/8/2012)
SQL Kiwi (1/7/2012)
Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.

The only reason I got this right is that only one of the four options had a valid parametername - all the others would have been uncrecognised so that null would be returned. Judging by the explanation, Steve ment to have client_net_address (but that wasn't an option).


That is also the only reason I got this correct. No other option was valid. But the correct answer doesn't seem correct to me. I interpreted the question to be asking for the IP of the Client and not the IP of the server that the client connected to.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1232138
Posted Sunday, January 8, 2012 9:01 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:13 PM
Points: 33,100, Visits: 15,210
Doh, copied the wrong item.

corrected.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1232184
Posted Sunday, January 8, 2012 9:32 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:56 AM
Points: 5,575, Visits: 24,824
Steve Jones - SSC Editor (1/8/2012)
Doh, copied the wrong item.

corrected.


Too much snow boarding without sun glasses ?


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1232190
Posted Sunday, January 8, 2012 11:01 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 21,342, Visits: 15,017
Steve Jones - SSC Editor (1/8/2012)
Doh, copied the wrong item.

corrected.


Glad to see our complaining was effective




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1232203
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse