Hi All,
I'm developing a centralised system using MS SQL Server 2000. I want my system running on local database if the main server is down.
1. How do I detect the connection to main server is fail and switch to local database(using MS SQL Server 2000 as well)?
2. How do I update the server database when the connection is up from local database?
For ur information, only 1 table need to be updated in database server and there are table relationship involved in main database. I really dont know how to start
? Can any one give me idea n sample code where I can start on it?
rgds,
jpdbay
I'm developing a centralised system using MS SQL Server 2000. I want my system running on local database if the main server is down.
1. How do I detect the connection to main server is fail and switch to local database(using MS SQL Server 2000 as well)?
2. How do I update the server database when the connection is up from local database?
For ur information, only 1 table need to be updated in database server and there are table relationship involved in main database. I really dont know how to start
? Can any one give me idea n sample code where I can start on it? rgds,
jpdbay
