If you want to insert values into two tables, regardless whether the tables are in the same database or on two different database, you have to issue 2 separate INSERT statements for each table. If you want to issue just 1 INSERT statement, then the table where you are inserting the data must have a trigger that will insert into the second table.
SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp