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 |
|
Gom
Starting Member
4 Posts |
 Posted - 2009-05-21 : 04:56:53
|
| Hi,I am executiong my sqlprofiler.I want to check the host_name or IPAddress of the user..Becoz its easy to track the users activity on the database..when i run the profiler it has given the eventclass,spid,clientprocessid,textdata etc..how to identify the users activity through sqlprofiler |
|
|
jholovacs
Posting Yak Master
163 Posts |
Posted - 2009-05-21 : 10:18:33
|
In the events selection tab,check the "Show All Columns" box, select HostName for all events. Click on the Column Filters button, select the Hostname column on the left, expand the Like operator, and type in the name of the hostname.
SELECT TOP 1 w.[name]FROM dbo.women wINNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_idWHERE i.net_worth > 10000000 AND i.status IN ('dead', 'dying') AND w.husband_id IS NULLORDER BY w.hotness_factor DESC |
 |
|
|
|
|
|
SQL Profiler