FIX: Stored Procedures Created from Other SPs Have no Entry in Syscomments (201403)



The information in this article applies to:

  • Microsoft SQL Server 6.5

This article was previously published under Q201403
BUG #: 17256 (SQLBUG_65)

SYMPTOMS

When a stored procedure is created from within another stored procedure, the Syscomments system table lacks any entries for the newly created stored procedure.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in U.S. Service Pack 5 for Microsoft SQL Server 6.5. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site: For more information, contact your primary support provider.

Modification Type:MajorLast Reviewed:7/19/2006
Keywords:kbBug kbfix KB201403