BUG: Management Studio is not able to display a NULL value

7 Apr 2006 12:50 PM

Franz

Hi,

I just came accros this problem this week. The RTM version of SQL Server
2005 Management Studio is not able to display a NULL value'd content of a
nullable UDT in the "Result to GRID" Grid control!

If I do have choosen "Result to GRID" and when I do a "select * from
MyTable" where a column of table MyTable is a nullable UDT and when I have
NULL values in the UDT's column, then I get the error message "An error
occurred while executing batch. Error message is: Data is Null. This method
or property cannot be called on Null values."

If I choose "Result to Text" then I will not get the error message, but a
properly displayed result set with my NULL values!

Needless to say that my UDT is properly implemented.

Regards
Franz

8 Apr 2006 12:19 PM

Erland Sommarskog

Franz (Fr***@discussions.microsoft.com) writes:
Show quote

> I just came accros this problem this week. The RTM version of SQL Server
> 2005 Management Studio is not able to display a NULL value'd content of a
> nullable UDT in the "Result to GRID" Grid control!
>
> If I do have choosen "Result to GRID" and when I do a "select * from
> MyTable" where a column of table MyTable is a nullable UDT and when I
> have NULL values in the UDT's column, then I get the error message "An
> error occurred while executing batch. Error message is: Data is Null.
> This method or property cannot be called on Null values."
>
> If I choose "Result to Text" then I will not get the error message, but a
> properly displayed result set with my NULL values!
>
> Needless to say that my UDT is properly implemented.

Thankfully this bug is fixed in Service Pack 1 of SQL 2005, which is
currently available in a CTP version.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx