Thank you very much for your feedback.  Let me work on implementing your suggestions

SELECT TOP(50) [c].[Barcode], [c].[BottomDepth], [c].[BoxCount], [c].[BoxNumber],

[c].[CertifiedDate], [c].[CheckedDate], [c].[Comment], [c].[Condition], [c].[ContainerName],

[c].[ContainerOwnerId], [c].[Core], [c].[CoreShift], [c].[CreatedBy], [c].[CreatedDate],

[c].[DepthMaxText], [c].[DepthMinText], [c].[FormationId], [c].[ImmediateContainer],

[c].[InUse], [c].[Interval], [c].[LogDepth], [c].[ModifiedBy], [c].[ModifiedDate], [c].[Movement],

[c].[NextCertificationDate], [c].[Notes], [c].[Permeablity], [c].[Porosity], [c].[PossiblePlugs],

[c].[Quality], [c].[RecordItemStatusId], [c].[SampleCount], [c].[SampleNumber], [c].[SerialNumber],

[c].[SetCount],...

SELECT TOP(50) [c].[Barcode], [c].[BottomDepth], [c].[BoxCount], [c].[BoxNumber],

[c].[CertifiedDate], [c].[CheckedDate], [c].[Comment], [c].[Condition], [c].[ContainerName],

[c].[ContainerOwnerId], [c].[Core], [c].[CoreShift], [c].[CreatedBy], [c].[CreatedDate],

[c].[DepthMaxText], [c].[DepthMinText], [c].[FormationId], [c].[ImmediateContainer],

[c].[InUse], [c].[Interval], [c].[LogDepth], [c].[ModifiedBy], [c].[ModifiedDate], [c].[Movement],

[c].[NextCertificationDate], [c].[Notes], [c].[Permeablity], [c].[Porosity], [c].[PossiblePlugs],

[c].[Quality], [c].[RecordItemStatusId], [c].[SampleCount], [c].[SampleNumber], [c].[SerialNumber],

[c].[SetCount],...

• This reply was modified 9 months, 1 week ago by  Siva Ramasamy.

Thank you very much for taking time to look into my question.  I will look into the link you provided.

Thank you. That did not work either. 

I went for a different approach. Started using change tracking instead of checksum.

THanks

I completely agree with you. My business scenario demands it.  The destination gets updated/inserted every night to keep historical data. I have to update the destination if the checksum values...

Yeah. That column with 4000 bytes is the issue.  If I take that out, the checksum value matches between the instances.  I even tried the following, but still no luck. 

Thanks for the response. 

Please find the query. I copied and pasted the same query in both the instances. 

SELECT

CONVERT(VARBINARY(32),HASHBYTES('SHA2_256',CONCAT([AGENCY_NUM],LTRIM(RTRIM([CARRIER_CODE])),[TS_D1],[EXT_FLAG],[FM_USERID],[TS_D2],[TOTAL_NUM_TXNS],[NUM_TXN],LTRIM(RTRIM([TXNS]))
))) AS...

Thank you Tom. Let me try that.

I am trying to connect to an old SQL Server 6.5 server.  SSMS wouldn't help me.  Could you please have me connect to your FTP site so that I can...

Thank you so much Handy D. 

I will post more updates as I make progress on this project.

Thanks

Here is a link that helps you how to implement it. 

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-2017

Thank you so much Srikanth for giving me the right direction...! I learnt something new today. 

Thank you SQL Server central for providing the platform...!

I have solved the issue.  Here is a good article that helped me. 

https://thesqldude.com/tag/version-store/

Yes. It is version store.   
Unfortunately, I am just exposed to VersionStore in tempdb. 

The following query helped me.
select getdate() AS runtime, SUM (user_object_reserved_page_count)*8 as usr_obj_kb,