How can I add a record to an SQL Server 2000 table using an ASP page? The Access way of using an ADO recordset with the command objrs.open SQLStoredProc 'param1', 'param2', objconn, , adlockoptimistic, adstoredproc does not work. I get a syntax error. If i run that sotored procedure from query analyzer it will work, so I know the problem is in the ADO and I can't find it. Can anyone help?