• Using the BINARY_CHECKSUM introduces a limitation to your solution. The BINARY_CHECKSUM function will only detect changes to columns of comparable types. This means that if you have columns declared as type text, ntext, image, cursor, xml, etc. then changes to those won't be detected.