Attaching AdventureWorksLT Physical Files to the Server in SQL Server


How to attach AdventureWorksLT physical files to the server in SQL 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'
   @filename2=N'C:\Program Files\Microsoft SQL Server'

USE AdventureWorksLT

SELECT TOP 10 CustomerID, FirstName, LastName, Phone 
   FROM SalesLT.Customer
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.


Installing Sample Scripts and Databases in SQL Server

⇒⇒SQL Server Database Tutorials

2016-12-02, 332👍, 0💬