Hi All,
Currently we have two databases both running on the same Install and
Machine under MSSQL, one of these database's has two triggers that
fire to update some tables on the other database, pretty normal upto
now.
The problem: we are looking to move one of the databases to another
instance of MSSQL on a different machine, different workgroup,
different location (separate installs of MSSQL). The only linking
factor being that both locations are connected and we can see both
workgroups from either location.
The reason: Being that the point in doing this is that at the minute
the other location have to connect via the web to access the database
that is solely for their work purposes, so we are moving to them,
however we update it with some data on one of our databases via two
triggers.
I would really appreciate it if somebody could help me with this, with
either;
*Explaining how i can write the trigger to do cross netowrk stuff.
*Setting up Remote / Linked Servers correctly
*Or anything anyone else can suggest.
Relativly new to doing this stuff in SQL, and would be glad for the
help.
Sway