Client Test Program for a SQL Cluster

To help in visualizing exactly what effect a SQL Server failure and subsequent fail-over may have on an end-user application, we have created a small test program using Visual Studio .NET 2003. This small C# (pronounced C-sharp) test program accesses the Northwind database that is included with SQL Server, and was created in about 10 minutes. It will display a few columns of data along with a couple of system variables that show connection information. This includes

  • CustomerID and CustomerName— A simple two-column display of data from the customer table that meets the selection criteria

  • ServerName— The SQL Server name that the client is connected to

  • SHOWDATETIME— The date and time (to the millisecond) of ...

Get Microsoft® SQL Server High Availability now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.