You have several options.

If the databases change very infrequently and on a schedule, you could
backup/restore or sp_detach, sp_attach.

If changes are more frequent and/or unscheduled you might try either
Log shipping ( this is part of database maintenance plan wizard in the
Enterprise Edition) or
Replication which is in all SQL Servers.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

In news:40f7bf82$0$6443$ed9e5944@reading.news.pipex.net,
John D <dobjsonneNOSPAMhotmail.com> said:
[quoted text, click to view]

Look up "replication".

--
Steve

Does anyone have any idea how to syncronise two SQL identical tables across
a network, between servers?

We want to run our website from a SQL tables on the same server, but set up
so that if the main SQL tables across the network change, or the tables on
the web server change, the two seperate servers will
syncronise/update/trigger updates to the tables on each other?

We are running SQL server 2000.

AHA
John