Get Client IP Address in SQL Server

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

slawomir.adamski SSC Enthusiast Points: 130 More actions · Answer 1

SSC Enthusiast

Points: 130

August 5, 2014 at 2:12 am

LearnModeOn SSC Enthusiast Points: 154 More actions · Answer 2

Using SQL 2008 R2

The second method gave me the result of <localhost>

The first method created the function correctly, but didn't display a result.

I tried this, but something is wrong?

DECLARE @IPADDY nvarchar(255)

EXECUTE [dbo].[GetCurrentIP], @IP_Address=@IPADDY OUTPUT

PRINT @IPADDY

Thanks!

select this!!

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

SSC Guru

Points: 76202

October 27, 2015 at 7:23 am

Cool, thanks.

TriggerMan Say Hey Kid Points: 672 More actions · Answer 4

Say Hey Kid

Points: 672

October 27, 2015 at 8:25 am

Pretty neat! Thank you sir.

Cookies on SQLServerCentral