hi, i need to synchronize a table from a database to two tables on a different database. I was thinking in a stored procedure to do it and create a job that execute it every minute.

I don't know if this is the right method... maybe it can be a bad decision for the server performance.

Anyone can help me to do that?

Thanks.

Daniel Gil

You may want to consider doing a trigger.

Depends on the volume of data your dealing with. A trigger can be setup when you insert or update a value in table one. It fires and takes that data and can send it to a remote location. In your design if no records changed, you would fire the stored proc off 60 times an hour. A trigger fires off for every insert, update or delete or whatever you set it up for.