SQL Server datatype equivalent to Access 16 byte hexidecimal replication id

• pgouellette

  Grasshopper

  Points: 13

  More actions

  June 16, 2008 at 1:57 pm

  #381142

  I am linking Access tables to SQL server for backup purposes and many of the Access tables have datatypes of Access replication id. In the SQL server tables i want to store the rep id generated in Access as the 16 byte hexidecimal value. How can I do this? Do I have to create a user defined data type, if so how would i do that for my situation?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  June 17, 2008 at 8:31 am

  #829825

  You could use binary(16) for that, I think. Try that out.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon