Technology Geek

When you download the SQL Server 2008 Express which is free. Did I mention?, no sample database is installed by default to work on, you have to download a sample database from Microsoft designated download site [Codeplex]. If you go to the download site and think about to download it then think again, look at download size, crap. To work with the sample database for learning I think this database size is huge [60 mb].

That’s why I’m providing the SQL script for creating the AdventureWorksLT 2008 database with sample data, which works great for SQL Server 2008 [all editions], basically I didn’t creating it for myself, I just downloaded the 60 mb zipped file for creating all provided database and used Generate Scripts menu command from the SQL server management studio.

I’ve provided this download on Codeplex, which is small in size [525 kb] and enough to get started with SQL server 2008 Express. This sql script will create Database and all objects with sample data to work with.

You can download this Sample script from CodePlex

If you find any problem then please create a issue on the Codeplex project page.

Hope this works!