Hello,
We rely heavily on UUID's. We use ColdFusion's UUID generator. As long as you have NIC the UUID is guaranteed to be universally unique for at least a few thousand years..
SQL 7 can also generate a GUID which is the same thing more or less.
The UUID generation algorithm uses the machines Mac address to make it universally unique so if you do not have a NIC then it can only be guaranteed unique to that one machine.
Jeremy Allen elliptIQ Inc.
>-----Original Message----- >From: Thomas Chiverton [mailto:thomas.chiverton@exodus.net] >Sent: Monday, April 02, 2001 4:17 AM >To: CF-Talk >Subject: RE: CreateUUID() > > >I have not used it, but I believe it is at least as unique as things like >NT's station ID etc. > >I wouldn't worry about it. > >-----Original Message----- >From: Dylan Bromby [mailto:dylan@bromby.com] >Sent: Monday, April 02, 2001 2:45 AM >To: CF-Talk >Subject: CreateUUID() > > >Does anyone on this list rely on CreateUUID() for creating a completely >unique identifier? Anyone know how it compares in effectiveness to using >uniqueidentifier and making it a row GUID in SQL? > >