How to get In my machine IP?

Question

How to get own machine IPV4 IP address in sql server?? help me.

Sanjeev Kumar · Answer

select CONNECTIONPROPERTY('local_net_address') select CONNECTIONPROPERTY('client_net_address')

Abhishek Chadha · Answer

hi refer to this - http://www.c-sharpcorner.com/code/2352/find-public-and-remote-ip-in-c-sharp.aspx

Vinay Singh · Answer

Hi Try this: SELECT CONNECTIONPROPERTY('local_net_address') AS local_net_address Or: SELECT SERVERPROPERTY(N'MachineName'); Or: SELECT @@SERVERNAME;

Rajeesh Menoth · Answer

Hi Try this code SELECT dec .local_net_address FROM sys.dm_exec_connections AS dec WHERE dec .session_id = @@SPID; Reference : http://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address

Nitin Sontakke · Answer

Please specify exactly what you want. It doesn't really makes sense to me.