Allowing All Columns to be Nullable

Some data sources do not provide an accurate way to report columns that are nullable or not. In addition, SQL Server occasionally reports a column as not-nullable, even though it actually contain NULL values.

SQL Server fails badly if it encounters a NULL value in a not-nullable column. A workaround for this is to report all columns as nullable, regardless of what the underlying data source is reporting.

To do so, you must edit the Windows registry. Follow these steps:

1. Open the Windows Registry Editor. One way to do this is to open a Command Prompt and enter regedit.
2. In the Editor, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\CData\CData SQL Broker\config.
3. Right-click the Config folder and select New > DWORD (32-bit) Value.
4. In the window that opens, set the following:
   • Value name: AllColumnsNullable
   • Value data: 1
   • Base: Hexadecimal
5. Click OK.