Geographic Locations in a database

Hi

Has anyone ever tried to store international address information in to a single data

example

UK Address
Nildram Ltd
Ardenham Court
Oxford Road
AYLESBURY
BUCKINGHAMSHIRE
HP19 3EQ
GREAT BRITAIN

US Address
CHRIS NISWANDEE
BITBOOST SYSTEMS
421 E DRACHMAN
TUCSON AZ 85705
USA

Spainish Address
Organismo Autnomio Correos y Telgraphos
Area de Asuntos Internacionales
Calle Aduana, 29
28070 MADRID
SPAIN

Has anyone ever normalised this information into a database, because Im not sure if I should create separate tables or US States etc. Are there any other countries that contain data such as states?

Im just wondering how large organisation such as Yahoo or Microsoft would store this information.

Regards
Bennettas you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.

Geo Diverse SQL Server site locations

Looking for a couple options to setup a geo-diverse sql cluster configuration
between two separate site locations. Trying to determine what tryp of
replication I should use and/or creating transactional and snapshot
publications. The sites will have the same high end hardware for the servers
and SAN arrays. We utilize about 4 databases with one of them being the
master DB for history of our services. Any input is helpful.
Corey
Depending on the SAN vendor, they have some solutions out there.. Or else
there are 3rd party products from NSI, Xosoft,Neverfail just to name a few
that can help
"Corey" <Corey@.discussions.microsoft.com> wrote in message
news:E703FBF0-8671-4308-A929-DEC2DA58DECC@.microsoft.com...
> Looking for a couple options to setup a geo-diverse sql cluster
configuration
> between two separate site locations. Trying to determine what tryp of
> replication I should use and/or creating transactional and snapshot
> publications. The sites will have the same high end hardware for the
servers
> and SAN arrays. We utilize about 4 databases with one of them being the
> master DB for history of our services. Any input is helpful.
> Corey