BUG: Fully Qualified Names Required for System SPs in SPs

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q151115

BUG#: 15191

Expand all | Collapse all

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.

Back to the top

WORKAROUND

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

Back to the top

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.

Back to the top

APPLIES TO

Microsoft SQL Server 6.5 Standard Edition

Back to the top

kbprogramming KB151115

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top