Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Server
I have tried to figure out through google and found the following query but its not worth for me.
 
SELECT * FROM db.sys.columns WHERE object_id = OBJECT_ID('db.SchemaName.table1')
 
I am using sql server 2005 and i am not using any linked database concept ,i can say one is server db and another is client DB . Both database are with same name and same structure but in different machine . i just need to mirror one database into another . For that reason first i need to check whether there is any new record in one DB.
Posted 17-Apr-13 1:23am
Edited 17-Apr-13 2:25am
v4
Comments
CHill60 at 17-Apr-13 6:28am
   
Firstly - Use the Improve question link to post the version of SQL Server that you are using as there are more tools available in later versions.
Secondly - have you set up either of the databases as a Linked Database to the other?

1 solution

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

Solution 2

To query across the Database servers you need to have linked server setup, if you cannot set the linked server.
 
You can load data from both server into once common server, then compare using SET operators like UNION, NOT EXISTS, alternatively you can use PowerPivot do to the same.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 525
1 Maciej Los 319
2 BillWoodruff 174
3 Suraj Sahoo | Coding Passion 170
4 /\jmot 152
0 OriginalGriff 8,654
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,639
3 Maciej Los 5,229
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 27 Apr 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