How to get In my machine IP?

Nirmal Roy

10y1.1k

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

help me.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

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

Try this:

SELECT CONNECTIONPROPERTY('local_net_address') AS local_net_address,

Or:

SELECT SERVERPROPERTY(N'MachineName');

Or:

SELECT @@SERVERNAME;

Rajeesh Menoth10y ago
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
0
Sanjeev Kumar10y ago
select CONNECTIONPROPERTY('local_net_address')
select CONNECTIONPROPERTY('client_net_address')
+1
Nitin Sontakke10y ago
Please specify exactly what you want. It doesn't really makes sense to me.
0