i want to ask you that how can i catch the hostname from the query request over a web server. the profiler only shows the host name of the web server. and as you know there is only one web server db user. so i cant catche the username difference.
but i need to distinquish the users by their host name.
is there a way to do this ? or do i have to cry ?

thanks
MS Sql Server LazyDBA home page