How to attach AdventureWorksLT physical files to the server?

Submitted by: Administrator
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
<pre>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</pre>

Looks like the sample database AdventureWorksLT is ready for you play.
Submitted by: Administrator

Read Online MS SQL Server Job Interview Questions And Answers