Category: SQL Server

Microsoft provides sample SQL Server databases called AdventureWorks. You can download the files from the CodePlex website for your relevant SQL Server version here – http://msftdbprodsamples.codeplex.com/.  You can then attach the databases to your SQL Server instance. To do this, copy the files to a location on the SQL Server and run the following command: CREATE DATABASE [AdventureWorks2012] ON (FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf’) FOR ATTACH_REBUILD_LOG GO CREATE DATABASE [AdventureWorksDW2012] ON (FILENAME … Continue reading Installing Microsoft SQL Server AdventureWorks Sample Data

To install SQL 2005, go through the following steps. Select Install->Server Components: You may get this message here. This install is on a Windows 2008 R2 server. Select Run Program. We will install service packs later. Select Next: Select Next: Select Next: Select Next: Confirm your registration keys and select Next: Select the components you want to install: Select Advanced and ensure Client Components is checked for Management Tools: Select … Continue reading SQL 2005 Install