BUG: Table Designer Cannot Create a Bit Column Which Allows NULL

• Microsoft SQL Server version 7.0

SYMPTOMS

When using the SQL Server Enterprise Manager Table Designer to create a table, you cannot create a bit column that allows NULLs. The Allow Nulls check box will not accept a check mark.

WORKAROUND

To work around this problem, use Query Analyzer to issue the Transact-SQL CREATE TABLE statement. The CREATE TABLE statement allows you to create a nullable bit column. For example, use the following statement:

CREATE TABLE mytable ( f1 bit NULL ) 

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: prodsql

Keywords : kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug