Microsoft KB Archive/201403

= 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:

http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspx

For more information, contact your primary support provider.

Keywords: kbbug kbfix KB201403

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.