FAQ: How do I start playing with data in SQL Express, there don't seem to be any sample databases

SQL Express currently does not ship with any sample databases to help keep the size down, we'll be making these formally available on the web in the future but the folks over at ASP.Net have a nice tutorial that includes using the pubs database, so they have a page that shows you how to download and install pubs.

Its here.

 

-Euan Garden

Product Unit Manager

SQL Server Tools

Comments

• Anonymous
  July 04, 2004
  Would NWind and pubs sample DBs (http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en) updated to support SQL Express 2005?
• Anonymous
  July 05, 2004
  Sergey,
  Yes this installer's scripts will work. I just tried installing the scripts using sqlcmd, with the :r command inside the environment and it works fine