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.