0
Vote

AdventureWorks 2008 LT: The column ‘CustomerCol1’ of Table ‘Customer’ is missed

description

Environment:

  1. SQL Server Katmai
  2. SQL Samples
  3. Visio
     

Repro Steps:

  1. Open ‘<SampleRoot>\ Tools\Samples\AdventureWorks 2008 LT\ AdventureWorksLT.vsd’ via Visio
  2. Check the columns of table ‘Customer’
  3. Select Columns in DB ‘AdventureWorksLT2008’:
    select * from sys.columns
    where object_id=(select object_id from sys.tables where name='Customer')
  4. Compare the two column Lists
     

Expectation:

The Columns in two lists should be the same
 

Actual Result:

The column ‘CustomerCol1’ does not exist in Table ‘Customer’ of real DB.

comments