Microsoft KB Archive/201819

{|
 * width="100%"|

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

 * }

-

The information in this article applies to:


 * Microsoft SQL Server version 7.0

-

BUG #: 51191 (SQLBUG_70)

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

Technology :