| Author |
Replication of data in SQL Server
|
Anil Vupputuri
Ranch Hand
Joined: Oct 31, 2000
Posts: 527
|
|
Hi,
Reqt. is to replicate data in two DB servers(using Publication & Subscription in SQL Server2000) as data is synchronized , initially I fetch data from First DB server, if its down I go for Secong DB server and fetch the data and vice versa as this procedure continues throughout my application and so need to ping everytime I open a connection to DB server and check whether its running.
So, is there any other alternative to test whether connection object is alive to proceed to other server.
Thanks,
Anil
|
SCJP 1.5, SCEA, ICED (287,484,486)
|
 |
 |
|
|
subject: Replication of data in SQL Server
|
|
|
0
