Hi all,

I need help regarding sql triggers. I want to use a SQL trigger on a table in one database to trigger on updates of another database.

When user inserts records in table1 of Database1; the table2 of Database2 should get updated with a new record. Is it possible to write a trigger on table1 to achive this ?? I am working in SQL 2000.
How do I reference the second database with my SQL query?

Thanks and regards,
Shilpa