SQL 2008 GUID column is all 0's

Posted by Andy Evans on Stack Overflow See other posts from Stack Overflow or by Andy Evans
Published on 2011-01-16T00:50:54Z Indexed on 2011/01/16 0:53 UTC
Read the original article Hit count: 222

Filed under:
|
|
|

I'm hoping this is a simple goof I did on my end ...

I have a table in my database set up like so:

column name: widget_guid data type: uniqueidentifier allow nulls: false default value: newid() identity: false row guid: true

When records are created (via LINQ to SQL) that the values in this field are formatted as a GUID but contain all 0's

My assumption was that when a new record was created, that a guid would be autogenerated for that column, much like an auto-incrementing row id. Is this not true? Any help would be greatly appreciated.

Thanks.

© Stack Overflow or respective owner

Related posts about sql

Related posts about linq-to-sql