FIX: Stored Procedure Creation Gets Garbled Entry in Syscomments

• Microsoft SQL Server version 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 version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: prodsqlst proc sp sp5

Keywords          : SSrvStProc kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: May 4, 1999