• use this query for trigger or procedure it's get the ip address in sql server

    declare @ip varchar(40)

    exec sp_get_ip_address @ip out

    print @ip