• For those who take offense at the resurrection of old threads, I apologize, but there is an important issue that has arisen with the passage of time. Microsoft now says that the DEFAULT and RULE constructs are deprecated and should not be used. Seems to me that doing that invalidates a lot of the value of UDTs. Also, you can't use IDENTITY with a UDT.

    Jay Bienvenu | http://bienv.com | http://twitter.com/jbnv