How to download and install the scaled-down database AdventureWorksLT?
Submitted by: AdministratorIf you want to practice you DBA skills with the scaled-down version of the sample database AdventureWorksLT provided by Microsoft, you should follow this tutorial to download and install it first:
1. Go to the SQL Server 2005 Samples and Sample Databases download page.
2. Go to the x86 section in the Instructions section, Click "AdventureWorksLT.msi -- 2,251 KB" to download the sample file. Save the download file to c: emp.
3. Double click on the downloaded file: c: empAdventureWorksLT.msi. The installation setup window shows up. Follow the instructions to finish the installation.
When the installation is done, two physical database files are installed in the data directory: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData:
AdventureWorksLT_Data.mdf 5,120 KB
AdventureWorksLT_Log.ldf 2,048 KB
Submitted by: Administrator
1. Go to the SQL Server 2005 Samples and Sample Databases download page.
2. Go to the x86 section in the Instructions section, Click "AdventureWorksLT.msi -- 2,251 KB" to download the sample file. Save the download file to c: emp.
3. Double click on the downloaded file: c: empAdventureWorksLT.msi. The installation setup window shows up. Follow the instructions to finish the installation.
When the installation is done, two physical database files are installed in the data directory: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData:
AdventureWorksLT_Data.mdf 5,120 KB
AdventureWorksLT_Log.ldf 2,048 KB
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
| ☺ | How To Execute the Cursor Queries with "OPEN" Statements? |
| ☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
| ☺ | How To Convert a Numeric Expression from One Data Type to Another? |
| ☺ | How To Create a View on an Existing Table in MS SQL Server? |
| ☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
