Howdy, Stranger!

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

Categories

Triggers on two different Servers using sql server 2000

Hai,

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.