Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RowGuid Column Property
Message
From
18/12/2008 10:27:13
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01368502
Message ID:
01368512
Views:
20
Thanks Sergey,

Does the rowguid now get created by SQL Server on an insert as opposed to me creating it when I create records? I would assume so since the default value now says newid()
Tim

>It doesn't do anything besides indicating that the uniqueidentifier values in the column uniquely identify rows in the table. The uniqueness must be enforced through other mechanisms, such as the PRIMARY KEY or UNIQUE KEY constraints for the column.
>It's primarily used by SQL Server replication. In SQL 2008 it's also required by the new FILESTREAM feature.
>
>>If I set the Row Guid Column property for my PK to True as it is a UID, what does this actually do? It looks like the property for Default Value on the column also got set to newid() so that must have been related and the point of it.
>>Thanks
>>Tim
>>As you can tell, I am not so savy about SQL Server
Timothy Bryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform