FIX: Access Violation if Fully Qualified View Name Is Large

ID: Q124238

4.21a WINDOWS kbbug4.21a kbfix4.21a.sp1 kbprg

The information in this article applies to:

• Microsoft SQL Server, version 4.21a

BUG# NT: 935 (4.21a)

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.

Additional reference words: 4.21a view Windows NT KBCategory: kbprg KBSubcategory: SSrvWinNT

Last Reviewed: December 19, 1997