Hi
Is it possible to connect SQLSERVER 7.0 Database with SQLSERVER 2000 Database using LINKED SERVER, So that i should be able to insert data from one database into another(2000 to 7) using triggers.

The data will be entered in the 2000 database and using triggers i should be able to transfer the data into a table in sqlserver 7 database

(Both 7 & 2000 are in the Same network)

Regards
Venkat