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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-22 : 07:15:39
|
| Tate writes "Is it possible to update or replicate by means of broadcasting in sql server 2000? My servers are in the same LAN. Objective is to reduce the network traffic. Instead of replicating to one server at a time I want to update all servers at once.As I understand, at Ethernet level, IP Address, aaa.bbb.ccc.255 is a broadcast message to all servers. Can SQL server use this feature to broadcast the updates?Tate" |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-11-26 : 11:14:54
|
| How about PUSH subscription?------------------------I think, therefore I am |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-01 : 03:17:03
|
AFAIK, you need to define the subscribers one by one. you can however have multiple subscribers in one publication  --------------------keeping it simple... |
|
|
|
|
|
|
Broadcasting in SQL Server