title: How to read a remote xml file from SQL Server 2005
body: <p>Can I read a XML file from remote server such as</p>
  
  <p><a href="http://dealer.somedomain.com/data/inventory.xml" rel="nofollow">http://dealer.somedomain.com/data/inventory.xml</a></p>
  
  <p>I need read and get data from this remote XML file and update some local tables.</p>
  
  <p>I use SQL Server 2005.</p>
  
  <p>Thanks in advance.</p>