Click here to Skip to main content
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
0 OriginalGriff 5,380
1 Sergey Alexandrovich Kryukov 4,693
2 Peter Leow 2,939
3 DamithSL 2,465
4 Maciej Los 2,230


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