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

ID: Q201403

The information in this article applies to:

Microsoft SQL Server version 6.5

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 version 6.5. This problem has been corrected in U.S. Service Pack 5 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:


Keywords          : SSrvStProc SSrvTran_SQL kbbug6.50 kbSQLServ650bug 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: June 8, 1999