FIX: Access Violation if Fully Qualified View Name Is Large (124238)


The information in this article applies to:

  • Microsoft SQL Server 4.2x
This article was previously published under Q124238

SYMPTOMS

SQL Server version 4.21a will suffer an access violation if the fully qualified name of a view becomes very large. This occurs if the fully qualified name exceeds 30 bytes on the Alpha versions of SQL Server, but may occur with larger names on the MIPS or Intel versions. The problem is specific to view names. It does no occur for other objects, such as tables or stored procedures.

WORKAROUND

If possible, shorten the name of the view.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.21a. This problem was corrected in SQL Server version 4.21a Service Pack 1, which is available from Microsoft Product Support Services. For more information, please contact your product support provider.
Modification Type:MajorLast Reviewed:3/24/2000
Keywords:kbbug KB124238
©2002 Microsoft Corporation. All rights reserved.