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 27-Feb-13 0:43am
Edited 27-Feb-13 0:44am
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 587
1 Sergey Alexandrovich Kryukov 479
2 Maciej Los 305
3 Mathew Soji 195
4 Afzaal Ahmad Zeeshan 170
0 OriginalGriff 7,356
1 Sergey Alexandrovich Kryukov 6,777
2 DamithSL 5,461
3 Manas Bhardwaj 4,916
4 Maciej Los 4,475


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 27 Feb 2013
Copyright © CodeProject, 1999-2014
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