Ways to compare and find differences for SQL Server tables and data
I have database uses a table to replicate data between the different servers. Once it replicates a service called the CMS Replication Service running on a web server adds it to SharePoint. When an artifact is uploaded at a servers it adds it to SharePoint and then it adds it to Journal (table). My lead believe we have some entries added to SharePoint that fail getting written to Journal. This there script I can use to check and then make sure everything that exists in Journal (table) exists in database (SharePoint database) which has and vise versa? Thank you so much!