Answers

Question and Answer:

  Home  MS SQL Server

⟩ 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 FilesMicrosoft SQL Server'

+'MSSQL.1MSSQLDataAdventureWorks_Data.mdf',

@filename2=N'C:Program FilesMicrosoft SQL Server'

+'MSSQL.1MSSQLDataAdventureWorks_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.

 133 views

More Questions for you: