Inserting info into diffrent tables in diffrent databses 1

[octavian10]

I am writing an application that requires me to insert information from a text box into 2 diffrent tables. Very easy! The problem I am having is that these two tables are in diffret databases, on the same SQL Server. I will ask this question in the SQL section also in case this can be done with a stored procedure. Any help would be greatly appreciated.

 

[mattyboy2000]

If you use three level naming when refering to your tables, you can access different databases on the same server:

Database1.dbo.Table1
Database2.dbo.Table2

Hope this helps



Matt