GUID (newid)

[ResolutionsNET]

Hi,

Can anyone help!

We have two databases (one a copy of the other).

In one table we generate an id using newid() as the default value for uniqueidentifer.

This works perfectly on one machine, but on the other all the uniqueidentifers as sequentially based. why, how???

The machines in question are NT 4.0 running SQL Server (sp 2).

Help.

 

[chiph]

The database configurations are identical on both machines? The ones doing the sequential numberings don't have any triggers or anything? And the datatype for both is the same?

Probably a stupid question - do the other machines have network cards? The GUID is based partly on the NIC's burned-in address. Oh wait, it's also partly based on the date/time. So that can't be it.

Chip H.