Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using Triggers to update external databases

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-23 : 13:02:30
Gary writes "I'm sure this is something that is extremely common; however I am relatively new to stored procedures/triggers and haven't found too much online info related to what I am trying to do. I was wondering if someone could show me an example of how a trigger in SQL Server 7.0 can be used to transfer data from the SQL Server database to another external database such as Oracle or Access (or even update data that was previously transferred - i.e. if the data in the SQL Server database was updated and subsequently needed updating in the external databases."
   

- Advertisement -