How to copy an ASP/MS SQL site to a local machine

Customer wants to copy his/her site to a local PC to show off in a "live" demo.

You might want to look at http://www.w3schools.com/asp/asp_install.asp.
It has a brief tutorial on how to set up Personal Web Server on a
PC/Laptop which supports ASP (maybe not a full implementation, but
still might be enough for your needs).

As for the MS SQL portion, you can definately look at MSDE from Microsoft: http://www.microsoft.com/sql/msde/default.mspx. It's a stripped down version of MS SQL 2000, which may or may not be enough for your needs.

Once you are ready to copy the site, just copy all of the web content
off of the server to your laptop into the predefined folder set up in
PWS and then "dump" the database from the MS SQL 2000 server in our
cluster and reimport it into your MSDE, changing hard links where/if
appropriate. That should get you all set up and ready to go.