Microsoft KB Archive/151115

= BUG: Fully Qualified Names Required for System SPs in SPs =

Article ID: 151115

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q151115



BUG#: 15191



SYMPTOMS
If you are not logged on as SA and create a stored procedure that calls any system stored procedure without qualification, you will get the following message:

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_help'. The stored procedure will still be created.



WORKAROUND
Specify the system stored procedure name as master.dbo.procedure_name.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbprogramming KB151115

-

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

© Microsoft Corporation. All rights reserved.