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.
Â
2016-12-02, 1243👍, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...