Attaching AdventureWorksLT Physical Files to the Server in SQL Server

Q

How to attach AdventureWorksLT physical files to the server in SQL Server?

✍: FYIcenter.com

A

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.

 

Installing Sample Scripts and Databases in SQL Server

⇒⇒SQL Server Database Tutorials

2016-12-02, 243👍, 0💬