Click here to Skip to main content
10,500,000 members (75,822 online)
Rate this:
Please Sign up or sign in to vote.
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.
Posted 26-Feb-13 23:43pm
Updated 26-Feb-13 23:44pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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[^]

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170713.1 | Last Updated 27 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100