Triggers on two different Servers using sql server 2000


As i am new to Sql Server 2000, i got a problem in creating Triggers.

Problem is

I need to create a trigger on one table in one server that should effect the table in another server.

for example
there are two servers
test1-(first server)-t1 (databasename)-ta1(tablename)
test2-(second server)-t2(databasename)-ta2(tablename)

now i need to connect first to test1(first server)-t1(database) and to write a trigger on test1 table ta1 that should effect the test2 server table(ta2)

plz write me with this example

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!