As i am new to Sql Server 2000, i got a problem in creating Triggers.
I need to create a trigger on one table in one server that should effect the table in another server.
there are two servers
test1-(first server)-t1 (databasename)-ta1(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