Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Attaching AdventureWorksLT Physical Files to the Server

By: FYIcenter.com

(Continued from previous topic...)

How to attach AdventureWorksLT physical files to the server?

After installed the sample database AdventureWorksLT, you need to attach it to your SQL server to make it available by follow this tutorial:

EXEC sp_attach_db @dbname=N'AdventureWorksLT', 
   @filename1=N'C:\Program Files\Microsoft SQL Server'
      +'\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
   @filename2=N'C:\Program Files\Microsoft SQL Server'
      +'\MSSQL.1\MSSQL\Data\AdventureWorks_Log.ldf'
GO

USE AdventureWorksLT
GO 

SELECT TOP 10 CustomerID, FirstName, LastName, Phone 
   FROM SalesLT.Customer
GO
CustomerID FirstName LastName   Phone 
1          Orlando   Gee        245-555-0173
2          Keith     Harris     170-555-0127
3          Donna     Carreras   279-555-0130
4          Janet     Gates      710-555-0173
5          Lucy      Harrington 828-555-0186
6          Rosmarie  Carroll    244-555-0112
7          Dominic   Gash       192-555-0173
10         Kathleen  Garza      150-555-0127
11         Katherine Harding    926-555-0159
12         Johnny    Caprio     112-555-0191

Looks like the sample database AdventureWorksLT is ready for you play.

(Continued on next topic...)

1. What Samples and Sample Databases Are Provided by Microsoft?
2. How to download and install SQL Server 2005 Sample Scripts?
3. How to download and install the scaled-down database AdventureWorksLT?
4. How to attach AdventureWorksLT physical files to the server?
5. How AdventureWorksLT tables are related?
6. How to add an address record into AdventureWorksLT?