Collections:
Attaching AdventureWorksLT Physical Files to the Server in SQL Server
How to attach AdventureWorksLT physical files to the server in SQL Server?
✍: FYIcenter.com
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.
⇒ AdventureWorksLT Entity Relation Diagram in SQL Server
⇐ AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server
2016-12-02, 3149🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...