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)
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads