I am relatively new to SQL Server's tools. I am on the following situation:
On several stored procedures on a database D1 on server S1, I need to use data that is stored on a database D2 on server S2, on a table that is being constantly updated.
As far as I've read, I can use SQL Server Integration Services to automate this task and sync two tables between two different servers/databases.
What I want to do is to have a "mirror" table from S2/D2 on S1/D1. So my stored procedures could use that table transparently.
Could you give me some any guidance? Thanks so much.