InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 01:52:47 GMT20http://www.sqlservercentral.com/Forums/Topic1309477-1665-1.aspxa touch overkill to get the hostname for sessions on your server perhaps?select s.host_namefrom sys.dm_exec_connections C join sys.dm_exec_sessions S on S.session_id = C.session_IDwhere C.client_net_address = '127.0.0.1'will provide the same information a lot simpler and safer than allowing a CLR on your system with External_AccessHowever as an approach to allow a dns lookup from within sql server this is effective. I wrote something very similar 6 years ago when i was analysing web server logs associated with identifying click fraud and needed to do a lookup and at times a reverse lookup to fill the gaps in the data as provided by the logs.Sat, 02 Jun 2012 11:12:10 GMTBill Galashanhttp://www.sqlservercentral.com/Forums/Topic1309477-1665-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/CLR/90565/">T-SQL CLR to query session hostname</A>[/B]Thu, 31 May 2012 21:55:15 GMTRepriser-991084