how to replicate table data from one server to oth

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

Transact-SQL (2000)

how to replicate table data from one server to oth

Author

Topic

babu
Starting Member

5 Posts

Posted - 2005-05-24 : 07:13:33

Hi Friends

I had problem

I 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 table
This 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 example

Thanks In Advance

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-05-24 : 07:45:03

From Server1, run this

Insert into OPENROWSET('SQLOLEDB','ServerName';'username';'password',
'SELECT * FROM DBname.dbo.tableName' ) select * from tableName

Madhivanan

Failing to plan is Planning to fail

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-05-24 : 07:48:26

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50186

When you stop replicating the post in every section you might get an answer.

Damian
Ita erat quando hic adveni.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources