title: SQL Server 2008 GUID column is all 0's
body: <p>I'm hoping this is a simple goof I did on my end ...</p>
  
  <p>I have a table in my database set up like so:</p>
  
  <pre>
  column name: widget_guid
  data type: uniqueidentifier
  allow nulls: false
  default value: newid()
  identity: false
  row guid: true
  </pre>
  
  <p>When records are created (via LINQ to SQL) that the values in this field are formatted as a GUID but contain all 0's</p>
  
  <p>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.</p>
  
  <p>Thanks.</p>