edit - forgot, registration required. its free and definately worth it.
Map IP Address to a Geographical Location - SQLServerCentral Quote:
Map IP Address to a Geographical Location
By Oscar D Garcia, 2009/07/09
...
With this article, I was able to show a simple process to create your own GEO lookup database and provide a solution to map the IP address to its location information. There are still other items to consider like automating the import process to download the new files, convert the IP address to the IP Num value, integrate this information in a data warehouse, and create reports that will show your marketing team in what regions the customers are located.
|
SQL: Map IP Address to a Geographical Location 
Linear Mode
