Symptoms
Using the "AutoGUID" smartobject property does not seem to work on a SQL based smartobject.
Diagnoses
This was a miss-configuration issue when creating the SQL table. You have to enter "newid()" as the default value if ID field on the table.
Resolution
After the SQL table was updated and the smartobject refreshed, all was well.