title: Resolve hostnames with t-sql
body: <p>How can i resolve a hostname in t-sql?   a 2000 compatible method is preferred.  Although something that works on 2005/2008 would also be helpful.</p>
  
  <p>eg.  If i have the hostname stackoverflow.com i want to return  69.59.196.211</p>