Use UUIDs (Universally Unique IDentifiers), also known as GUIDs (Globally Unique IDentifiers) to uniquely identify rows in a table.
The values are generated such that a value produced on one computer does not match a value produced on another computer. UUIDs can therefore be used as keys in replication and synchronization environments.
See the NEWID function in Reference: Building Blocks, Tables, and Procedures.