By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,506 Members | 1,876 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,506 IT Pros & Developers. It's quick & easy.

Firing Triggers from 1 SQL Server to another

P: n/a
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
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.