You'll need to populate the fields with NewId(), either as a default value or in a subsequent UPDATE command.
>Help. We are creating a script which will create and setup all SQL7 tables for a customer who purchases our software. Once the software is purchased we will not have the access to their SQL server. The problem that we are having is, the script will not create the guid. The script does not error but when the tables are created there is no guid. What am I doing wrong, is there a parameter that needs to be turned on or off inside the script to allow for a guid to be script generated or what?
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell