I have a requirement to send data from my database to another databse which is in different server. I want to do it using trigger. Can you please guide me how to do this. In case there is any other better method available then please let me know.
I did not get any useful Info from searching High Availability in BOL. I just want to know if its technically possible in SQL server 2008 to transfer data from database in one server to database in another server. I have a table in Server A and I want to write a trigger on the table to update the data in a table in server B. How can i do it using triggers or do I need to use some other method.
Senthil, I have requirement to update only 1 table from server 1 to server 2. Update in server 2 should happen when there is update in server 1 table. Now how do I access the table in server 2 database inside the trigger. Will replication solve this?