>>>We do this using replication.
>>
>>Can you elaborate more on that topic?
>
>http://www.code-magazine.com/Article.aspx?quickid=0311101
>http://msdn.microsoft.com/en-us/library/aa933510(SQL.80).aspx
>
>I don't know what version you have (I just saw the 6.5 and earlier - sorry about that), but these are nice:
>
>http://blogs.msdn.com/euanga/archive/2006/07/18/668916.aspx
>http://www.sqlteam.com/article/replicating-sql-server-2000-across-heterogeneous-databases
>
>A neat script for 2005 to get schema options:
>
>http://www.replicationanswers.com/ScriptSchemaOptions.asp
>
>
>A good site on replication scripts period:
>
>http://www.replicationanswers.com/Scripts.asp
>
>Now that I see you are using an older version, your replication options are limited.

I'm guessing Michel still didn't update his default UT account settings :)