Unique record identifier alternatives

  • Thread starter Thread starter dave chaffee
  • Start date Start date
D

dave chaffee

I am using SQL Server and SQL Server CE (with merge replication) for my
application. Users will be adding records for contacts they enter into
the application (contact id). I need to generate unique record
identifier for each contact entered. I read the threads on generating
GUID on the device, but the 16 byte field seems long (especially since
the contact ID will be used in other tables and need to join the tables
by contact id).

What other alternatives have people used for unique generating column
IDs that have proven successful?
 
a concatenation of a 2/3/4(?) bytes persistent app id + a 2/3/4 local unique
id ?
 
Back
Top