how to get user's IP Address in sql?

Question

Post reply

how to get user's IP Address in sql?

elham_azizi_62

SSCertifiable

Points: 5095
More actions
October 25, 2010 at 11:23 pm

#230362

hi all.
we want to log changing data such as isert,delete and update that users perform.we can do this.but now we want to khnow
which user do this changes?I want to get user's IP Address for this purpose,how to get user's IP Address in sql?

Viewing 4 posts - 1 through 3 (of 3 total)

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

Shanalise Hall of Fame Points: 3188 More actions · Answer 1

http://www.sqlservercentral.com/Forums/Topic473301-169-1.aspx

Suresh B. SSC-Insane Points: 22986 More actions · Answer 2

DMV sys.dm_exec_connections returns client IP. For example:

select client_net_address, session_id from sys.dm_exec_connections where net_transport = 'TCP'

Adiga One Orange Chip Points: 27284 More actions · Answer 3

elham_azizi_62 (10/25/2010)
hi all.
we want to log changing data such as isert,delete and update that users perform.we can do this.but now we want to khnow
which user do this changes?I want to get user's IP Address for this purpose,how to get user's IP Address in sql?

Instead of re-inventing the wheel, why not make use of the Default Trace running SQL Server 2005 and above? This trace captures the DDL changes as well. This article[/url] is a good start.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga