About new SQL Server 2005 Samples and Sample Databases

There are five msi files listed for downloading.

SqlServerSamples.msi

AdventureWorksDB.msi

AdventureWorksDBCI.msi

AdventureWorksBI.msi

AdventureWorksBICI.msi

What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for? I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove?

Thanks,

Hi,

Seems that they either need to update their docuementation or change the file names, because the BI (Business Intelligence) was former written wir DW (Datawarehouse). THE CI means (like mentioned in the download page) Case sensitive means, that for example 'A' is not the same as 'a'. more samples about that can be found here:

http://www.databasejournal.com/features/mssql/article.php/3302341

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jen,

Thanks. I are right, the CI means case insensitive.

AdventureWorksDB.msi creates a AdventureWork database with collation Latin1_General_CS_AS in your SQL Server.

AdventureWorksDBCI.msi creates a AdventureWork database with collation Latin1_General_CI_AS in your SQL Server.

Depends on the server collation setting (check the properties of server and see server collation item), you can decide which two msi files should to be downloaded and run on your machine.

Thanks,