Microsoft KB Archive/70847

PRSQL9103027: Cannot CONVERT to Image with an ORDER BY ID Number: Q70847

1.10 OS/2 buglist1.10 fixlist1.11

Summary:

PROBLEM ID: PRSQL9103027

SYMPTOMS A GP-fault occurs when CONVERT and ORDER BY are used to select data from the systypes table.

CAUSE Converting character type to text or image data in combination with an ORDER BY will cause this problem unless the column in the ORDER BY is part of a clustered, unique index.

WORKAROUND Select the converted information into a temporary table, then perform the ORDER BY on this temporary table.

STATUS Microsoft has confirmed this to to be a problem in SQL Server version 1.1. This problem has been corrected in SQL Server version 1.11, which is available from Microsoft Product Support Services. For more information, contact you primary support provider.