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, 2700🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...