We are changing master ID codes for security purposes and have been recommended to use CHECKSUM and HASHBYTES. CHECKSUM faild in some records and want to try HASHBYTES.
We understand CHECKSUM, but haven't quite grasp what is HASHBYTES and its format in use. Please give us an explanation.
The Master ID codes of the different tables ranges from length of 19 to 15.
Note: we running SQL 2000/2005