September 2010
Intermediate to advanced
1704 pages
111h 8m
English
To help in visualizing exactly what effect a SQL Server failure and subsequent failover may have on an end-user application, we have created a small test program using Visual Studio 2008. This small C# test program accesses the AdventureWorks2008 database available for SQL Server 2008 (see the Introduction chapter for information on how to download and install the AdventureWorks2008 sample database), and it was created in about 10 minutes. It displays a few columns of data, along with a couple system variables that show connection information, including the following:
• ProductID, Name, and ProductNumber—This is a simple three-column display of data from the Product table in the AdventureWorks2008 ...