vbuser1976
Programmer
I have two SQL servers with multiple databases in each one. I would like to be able to create a trigger on Server 1, database A, Table a to update data on Server 2, database B, Table b. Is it possible? Also, is it possible if the servers are two separate versions (Server 1 in SQL 6.5 and Server 2 is SQL 7.0)? I know you can create triggers from table to table within a database, but I want to be able to go to server/database to server2/database2 and I want to make sure it is possible before I start working on it.
Any comments would be greatly appreciated. -vbuser1976
VB6.0 SP4
Crystal 8.0 Developer Edition
SQL 7.0 SP2
Any comments would be greatly appreciated. -vbuser1976
VB6.0 SP4
Crystal 8.0 Developer Edition
SQL 7.0 SP2