Click here to Skip to main content
15,742,180 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
The application has one SystemDB and multiple customer databases. The customer databases are exactly the same(all tables are equal). The system databases contains a table with all the details from the customer databases like dbname, dbPassword,dbUsername, etc.. . If we insert Data in forms that should stored the data in all the databases.
Updated 26-Feb-13 23:44pm

1 solution

1. If the database resides in same server then use command like below
INSERT INTO DBName.dbo.Customer(Column1,Column2) VALUES('','')

2.If database resides in remote server.
As you told that you have DBName,Id password in one of your system table so using this value you can use OPENQUERY with dynamic SQL. For more information have a look[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900