Monday 22 July 2013

Get Client IP Address in SQL Server 

CREATE FUNCTION [dbo].[GetCurrentIP] ()
RETURNS varchar(255)
AS
BEGIN
    DECLARE @IP_Address varchar(255);
 
    SELECT @IP_Address = client_net_address
    FROM sys.dm_exec_connections
    WHERE Session_id = @@SPID;
 
    Return @IP_Address;
END
Posted by at

1 comment:

  1. sujoy santra22 July 2013 at 16:15

    1. To findout "SERVER NAME"
    SELECT SERVERPROPERTY('MACHINENAME')

    2. To findout "SERVER NAME" with "INSTANCE NAME" (If its Named Instance)
    SELECT SERVERPROPERTY('SERVERNAME')

    3. To findout "CLIENT MACHINE NAME"(Local Machine Name)
    SELECT HOST_NAME()

    ReplyDelete

Subscribe to: Post Comments (Atom)