Download adventureworks database for sql server 2008 r2

Adventureworks is one of the best free database for learning SQL Server objects, queries and more. This practice mostly useful for getting success in SQL Sever interviews


STEPS To install Adventureworks Database in SQL Server 2008.

2. Copy the DDL script files to C:\{AdventureWorks 2008 OLTP Script Path}. 
3. Open C:\{AdventureWorks 2008 OLTP Script Path}\instawdb.sql in SQL Server Management Studio. 
4. Update the script path variables. 

If necessary, change the :setvar SqlSamplesDatabasePath variable to your SQL Server 2008 path. The default path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER \MSSQL\DATA. 
Change the :setvar SqlSamplesSourceDataPath variable to the path containing the .csv files. 

5. On the Query menu, click SQLCMD Mode. 
6. On the Standard toolbar, click the Execute button to run the script.




Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar