Click here to Skip to main content
11,629,614 members (72,270 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server C#4.0
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
Edited 26-Feb-13 23:44pm
v2

1 solution

Rate this: bad
good
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
http://msdn.microsoft.com/en-us/library/ms188427.aspx[^]
  Permalink  
v3

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

  Print Answers RSS


Advertise | Privacy | Mobile
Web04 | 2.8.150723.1 | Last Updated 27 Feb 2013
Copyright © CodeProject, 1999-2015
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