I need a update trigger in one schema so that it can keep monitoring database table of other schema , both schema in residing on same machine , is it possible in SQL server 2000 ?
if yes than could some one help me with syntax to be used to create such update trigger
for example if i have schema abc and pqr than i need trigger residing in abc and it keep monitoring lets say table customer_detail in pqr if any change done in customer_detail should reflect tables present in abc..
CREATE TRIGGER pqr.test_trigger
SET some_field = x.some_field
, other_field = x.other_field
FROM abc.customer_detail As x
JOIN inserted As i
ON i.common_field = x.common_field