Check available SQL DAtabase Server
I am working on a C# windows application which sends data to MS SQL database server. We have two Data servers on different places with different names containing same data. I want to check for available Data server before sending data to any server, because if sometime data server is not available then application will give exception & updates for that event will not be recorded in any of data server.
Please help.
thanks in advance :)