Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fire1
Starting Member
5 Posts |
 Posted - 2002-12-24 : 01:24:09
|
| thank you!how can i get the user's ip address in the sqlserver?like:user name:fier1 ip address:157.82.2.32 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-12-24 : 02:07:15
|
| If you were to run a profiler trace you could get that. Otherwise, use a different tier to capture IP addresses. How are your users connecting ? Is it a VB app or ASP or something else ? Both of those solutions have ways of capturing that data.Damian |
 |
|
|
|
|
|
how can i get the users ip address in the sqlserve