BUG: Fully Qualified Names Required for System SPs in SPs

ID: Q151115


The information in this article applies to:
  • Microsoft SQL Server version 6.5

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 : kbprg SSrvStProc
Version : 6.5
Platform : WINDOWS
Issue type :


Last Reviewed: March 25, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.