Microsoft KB Archive/67327

PRSQL9012020: Views Contain “moneyn” Datatype ID Number: Q67327

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9012020

SYMPTOMS Executing sp_help on a view, the datatype “moneyn” is returned when the datatype “money” is expected.

CAUSE When executing sp_help on a view containing a column that has been algebraically derived from a money column (which allows nulls) and another numeric column (which does not allow nulls), you will receive “moneyn” as the datatype for that column.

This problem also occurs for float, int, and datetime datatypes.

STATUS Microsoft has confirmed this to be a problem in SQL Server version 1.10. We are researching this problem and will post new information here as it becomes available.