Posted by Sam Bendayan on 12/04/07 16:19

Greetings,

What is the point of Microsoft defining a ROWGUIDCOL property that can
be attached to a 'uniqueidentifier' column? This is defined as a column
that is 'globally unique', but doesn't the uniqueidentifier datatype
already guarantee that? To make matters more confusing, they tell you
in Books Online to add a Unique constraint because ROWGUIDCOL does not
guarantee uniqueness...so what's the point?

Apparently the only functionality attached to this property is that only
one such column can exist per table and that it can be queried using the
$ROWGUIDCOL keyword in SQL.

Can anyone tell me the rationale for when to use this and when not to,
or what the purpose of this property is?

Thanks,

Sam Bendayan
DB Architect
Ultimate Software
sam.bendayan@gmail.com

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Add a datestamp to an existing table
• Prev in forum: Re: multi column sub select equivalent for sql server 2005
• Thread view: What is the purpose of the ROWGUIDCOL property?

[Reply to this message]