FIX: Stored Procedures Created from Other SPs Have no Entry in Syscomments
Article ID: 201403
Article Last Modified on 7/19/2006
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
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.
Keywords: kbbug kbfix KB201403