>Do you create the GUID with a row global unique identifier column in SQL using NewId() as the default value for the field? If so, how do you retrieve the value of this field when a new record is inserted?

I think I would call the NewID() function explicitly. I do not know of a way to get the value back if you use NewID as the default for a column. And I would not think this is much overhead, going to the server twice (calling NewID, then inserting the record).