VS.NET 2005

I just got done installing VS.NET 2005 on my new desktop machine at home. I’m still working my way through ASP.NET 2.0: A Developer’s Notebook. I’m just starting the Data Access chapter. The limited version of SQL Server that comes with VS.NET does not have the pubs or Northwind databases installed by default. If you want to install them, you can find setup scripts for them under “C:Program FilesMicrosoft Visual Studio 8SDKv2.0SamplesSetup”, named InstPubs.sql and InstNwnd.sql. To run the scripts, do this:

sqlcmd -S .SQLEXPRESS -i InstPubs.sql
sqlcmd -S .SQLEXPRESS -i InstNwnd.sql

That seemed to be worth writing down, just in case I need to do it again…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.