>>AFAIK RowGuid sets the default value for the field to be NewID()
>
>My problem here is not the default value. I have a pk that is a UID. The ROWGUID property of the key is set to YES. I can change it manually to NO but I want to do it in TSQL.
>
>I have found that if I drop the PK entirely so that neither the key or the index or the column flag are showing anymore I still cannot create a new PK on that column with SMO as it still sees it as a rowguid.
>
>I thought blowing away the key would do it, since that was where the rowguid property was found, but it seems there is something else going on. I looked for a table property to reset but saw nothing there either.
Would you please post a script for the table? I asked my friends to help with this question.
If it's not broken, fix it until it is.
My Blog