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 ...