First, please clarify something -- do you mean insert into two different databases or two different tables in the same db?
I'll assume you mean two tables in the SAME database.You'll need to perform two different INSERT queries. You can only insert into one table at a time. If you need to perform multiple INSERT queries, use a transaction.
For SQL Server, you might as well just write a stored procedure that contains the transaction and pass the procedure your incoming data as parameters.
Take care,
Nik
http://www.bigaction.org/