title: Data difference between two database
body: <p>I am working on SQL Server 2005. I have took the backup and restore the database. I just wanted to know is there any way I can check whether the data between these two database are diffent. or any script that I can run or check [ could be table by table] to see if any new row added or modified.</p>
  
  <p><strong>EDITED</strong></p>
  
  <p>For example - I have to check the data difference from Database 1 Table_User to Database 2 Table_User.</p>
  
  <p>Thanks</p>