Easy enough to have a trace that grabs the host data for the connection, and then dump that into a table for analysis.
Would probably want to use events 14 and 17, columns 6, 7, 8, 11. (sp_trace_setevent)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon