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.
| Author |
Topic |
|
babu
Starting Member
5 Posts |
 Posted - 2005-05-24 : 07:15:37
|
| Hi FriendsI had problemI am having 3 servers(sql server) in same place with same database(same tables also)In one server I run a procedure the result will be inserted into a tableThis result should be inserted in the rest of 2 server table with out manual interaction How can I do it?Its most urgent?Give me with example like..by triggers.. or procedures....replication or indexed view please with exampleThanks In Advance |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-24 : 07:56:31
|
| I've kept this one open and locked the rest.Sorry Madhivanan, yours got caught up in the mess. You might want to repost it here.DamianIta erat quando hic adveni. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-24 : 22:34:12
|
| use replication instead of creating your own triggersi had this problem with one server where we defined how the data is to be transferred to the other server and it slowed down the target server not to mention produced some resource contention on the source server especially when doing deletesHTH--------------------keeping it simple... |
|
|
|
|
|
|
how to replicate table?