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 |
|
tamps
Starting Member
9 Posts |
 Posted - 2004-10-10 : 13:03:07
|
| i'm wondering, is there any option to get the IP Addr of the workstation currently accesing the SQL Server using the Profiler?tamps |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-10 : 13:52:25
|
| Not that I know of, but the MAC address is available in the sysprocesses table (net_address column). This might help you locate the computer on the network.BTW, one of the reasons IP address isn't visible is because SQL Server can use other network protocols besides TCP/IP. |
 |
|
|
tamps
Starting Member
9 Posts |
Posted - 2004-10-10 : 14:05:39
|
| havent used sysprocess before. are computers present here are members of the windows server whether they access the sql server or not, or computers connecting to the sql server only?tamps |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-10 : 15:37:23
|
| SELECT * FROM master..sysprocessesRun that statement from Query Analyzer. It will display all of the current processes/connections running on the SQL Server. The SPID column will match the SPID displayed in Profiler. However, the net_address column is not available through a trace, so you'd have to somehow periodically query the sysprocesses table and store the results permanently in order to match it back to Profiler events. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-10 : 23:30:57
|
| since you already know the workstation and i'm assuming you're working inside the lan, then you can use the name of the workstation to get the ip address.just an idea... |
|
|
|
|
|
|
IP Address