I built a form to collect user profile data in Front Page 2000.
Now I want to send it to a SQL 2000 db table on a remote server.
I also want to send a confirmation email to user.
What is the ASP script for this and how and where do I insert it on the FP page?

the first question is are you able to connect to a remote server database ?
my company and many others will not let an outside script connect to a database. the page running has to physically be on the same server as the databse (or at least the same account)