ASP working with SQL Server?

Hi,

Sorry by the lot of ignorance of my question, but I need working with large online databases: More than 50,000 records, pehaps 1,000.000 being visited by 500/1000 people by day!

Some people said "for large databases or for a high traffic of visits use SqlServer". Thus, I would like to know the following:



1. Can I use the scripts written in ASP for open tables/databases in MSACCESS to open databases in SQLServer?

2. Do you know a good online tutorial for ASP+SqlServer?
Thank you in advance

JanLee

Unless you have specific Access Functions in your code then you can use the same, standard, SQL for SQL Server.

Also, if you have any date/time functions then they would have to be rewritten.