FIX: Stored Procedure Creation Gets Garbled Entry in Syscomments (193043)


The information in this article applies to:

  • Microsoft SQL Server 6.5
This article was previously published under Q193043
BUG #: 16354 (NT: 6.5)

SYMPTOMS

The creation of certain stored procedures may cause garbled entries of the stored procedure text in the syscomments system table. The problem depends on the size and placement of the comments in the stored procedure, and it only happens when the packet size is set to 512. Also, the comment for the stored procedure must be located before the CREATE PROCEDURE statement for this problem to occur.

WORKAROUND

To work around this problem, do either of the following:

  • Use sp_configure or the Server Configuration/Options dialog box in SQL Enterprise Manager to change the 'network packet size' option.

    -or-
  • Put the CREATE PROCEDURE statement before the comment.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

For more information, contact your primary support provider.
Modification Type:MajorLast Reviewed:3/14/2006
Keywords:kbBug kbfix kbSQLServ650sp5fix KB193043
©2004 Microsoft Corporation. All rights reserved.