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
"John D" <dobjsonneNOSPAMhotmail.com> wrote in message
news:40**********************@reading.news.pipex.n et...
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