BUG: Sp_help on a User-Defined varbinary Data Type (88598)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q88598 SYMPTOMS
Executing sp_help on a user-defined data type of type varbinary
returns two rows, with Storage_type being of the types timestamp
and varbinary, respectively.
CAUSE
This problem occurs because both timestamp and varbinary have the
same type field value (37) in the systypes table. Sp_help does not
eliminate the special case for timestamp.
WORKAROUND
You can drop sp_help and recreate it after modifying the text of
the sp_help procedure to handle this correctly. Do this by
searching for the text "st.usertype != 18" to ignore the sysname
table and adding the following additional clause to the WHERE list:
and st.usertype != 80
This clause eliminates the condition for timestamp.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 4.21 and 4.21a. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbbug kbProgramming KB88598 |
|---|
|