Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have more questions, please feel free to let me know. Step 1 code Reads: EXEC spconfigure 'Database Mail. I would suggest installing a new instance of SQL Server 2008 and try the new AdventureWorks sample databases.įor more information about AdventureWorks, you can refer to Should read: AdventureWorks2008SR4.exe 25 Lesson Review, question 2, answer C Reads: QL Server Configuration Manager Should read: SQL Server Configuration Manager 27 Lesson Review, question 1 27 This question should be removed. There are schema changes as well as new tables added, besides in AdventureWorks2008 sample databases. What are the major differences between the 20 versions? So for both of questions, you don’t to uninstallĤ. During the installation, you need to specify an instance of SQL Server 2008 and all select databases will be installed on this instance. Hi all, I am working through Bill Pearson's tutorial Stairway to MDX - STEP 1: Getting Started with MDX.

What happens to my sample projects that are based on the 2005 if I must uninstall it before installing 2008?Īt least one instance of SQL Server 2008 is a prerequisite of installingĪdventureWorks2008_SR4.exe. Adventure Works DW 2008R2 Forum Learn more on SQLServerCentral. Note: When you execute the AdventureWorks2008SR4.exe, the executable not only installs the SQL Server 2008 version for the three AW databases, but it also installs the 2005 version of the three. An archive of the CodePlex open source hosting site. MUST I uninstall the 2005 AdvenWKs before installing 2008?ģ. AdventureWorks2008SR1.exe and AdventureWorks2008SR4.exe, and AdventureWorks2008 never shows up. Will install all AdventureWorks sample databases.Ģ. If you have an instance of SQL Server 2008, I would suggest installing the first setup which Which of the AdveWks DB do I download: AdventureWorks2008SR4.exe OR Both of two setups are for SQL Server 2008. Which of the AdveWks DB do I download:ĪdventureWorks2008_SR4.exe OR SQL2008.AdventureWorksLT2008_Only_Database.zipīoth of two setups are for SQL Server 2008.

Adventureworks2008 sr4 exe