Worked great. Thanks.
>>I have been trying to add a user defined type (domain) and I can't seem to be able to add a default value and no, I don't want to use a bit type.
>>
>>create type LOGICALFLAG
>> from tinyint not null default 0
>>
>>Thanks.
>
>The only way I've been able to make it work so far is this
>
>
>create type LOGICALFLAG
>from tinyint not null
>
>
>create default zero as 0
>execute sp_bindefault 'zero','LOGICALFLAG'