Hi. I am trying to set a default value for a bit column to true (in SQL Server 2000), but it only defaults to false. Is this a bug, or am I doing something wrong?
SQL server does not recognize true/false. Show the code.
Actually, I just discovered it's a MS Access problem. I was using an Access project to enter test data into the table, and apparantly Access is not respecting the default value.<BR><BR>Thanks anyway!