Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 uniqueidentifier / GUID seeds in merge replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-04 : 07:36:54
andresql writes "How does Microsoft SQL Server 2000 enforce the uniqueness of a uniqueidentifier / GUID? Does it use the product key or the name of the server? My client is considering using a ghost image with the site licensed copy of the disk image of a server for a roll-out. We are planning to use merge replication and I'm worried that the seed value will be the same and, therefore, allow collisions of values."

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-04-04 : 09:06:52
BOL Says..

A GUID is a unique binary number; no other computer in the world will generate a duplicate of that GUID value. The main use for a GUID is for assigning an identifier that must be unique in a network that has many computers at many sites.

generates new uniqueidentifier values from the identification number of their network card plus a unique number from the CPU clock.

Nothing to worry..

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page
   

- Advertisement -