MS SQL Server Concepts and Programming Question: Download Questions PDF
How to attach AdventureWorksLT physical files to the server?
Answer:
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.
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.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How to download and install the scaled-down database AdventureWorksLT? | How AdventureWorksLT tables are related? |