Not sure what the issue is. Does this work for you?
CREATE TABLE mike (
b bit DEFAULT (0)
, d datetime DEFAULT (GETDATE())
)
INSERT INTO mike DEFAULT VALUES
SELECT * FROM mike
How are you creating the default constraint? SEM? Code?
-Mike
>Using SQL Server 2000 I have a bit field and I enter a default value of 0 in the table designer. When I insert a new record the bit field does not default to 0, it is Null. When I create an SQL Script for the table the default value is not in the script. This is also true for a GetDate() function I put in the Default Value field for a date. No Default Values work at all.
>
>This is the first time I have tried creating Default Values. Is there a setup option I need to tweek or a configuration option to get this to work? Everything I do with Default Values are simply ignored. From the Help screens and searching messages here it seems like I can just enter the value in the table designer.
>
>What might I be missing here? Can anyone advise me?