Revised ReadMe File for the Updated XQuery.sln Sample Application

*** Revision 1 of 7/23/2005 for VS 2005 or VB Express Beta 2 (8.0.50215) and SQL Server 2005/SQL Express build 1116 of 4/9/2005 or 1187 of 5/24/2005 ***

(Search for Rev 1 to view the changes. SqlRecord and ExecuteRow replaced with SqlDataReader and ExecuteReader, sys.dm_db_index_physical_stats execution updated, and minor change made to XQuery query #2.)

1. This application requires VS 2005 or VB Express Beta 2 and SQL Server 2005 Developer Edition or SQL 2005 Express April CTP or later.

2. Extract the contents of this file into a folder named XQuery or the like. Be sure that the Use Folder Names check box is marked.

3. You must install the Northwind sample database before running this app. See SampleDatabases.txt for details. Launching the app for the first time adds two xml columns to the Northwind Orders table.

4. The default NorthwindConnection string expects a 'localhost' SQL Server instance. If you're running SQL Express, open the XQuery Properties window, select the Setting page, NorthwindConnection, and replace 'localhost' with '.\SQLEXPRESS'.

5. There are two additional application-level settings that you can use to speed opening the app after you open it for the first time:

Setting DropOrdersXmlOnStart to False eliminates the need to repopulate the two xml columns each time you open the app.

Setting CleanTablesOnStart to False eliminates the DBCC CLEANTABLE ('Northwind', 'Orders') instruction during Form_Load. This instruction was required for the SQL Server 2005 December CTP but doesn't appear to be necessary with later CTPs.

