Microsoft KB Archive/201846

= BUG: Reference to Deferred Object in Stored Procedure Will Not Show in Sp_depends =

Article ID: 201846

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q201846





SYMPTOMS
The output of sp_depends for an object created with dependencies on objects whose name resolution is deferred will not be correct. For an example of this, see the MORE INFORMATION section of this article.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
To reproduce this problem, use the following Transact-SQL code:

use pubs go drop proc abc1 go create proc abc1 as select au_id into #a1 from authors insert into #a1 select au_id from titleauthor go sp_depends abc1 go

SQL Server 6.5 will return the following:

In the current database the specified object references the following:

name                                    type             updated selected --- dbo.authors                             user table       no      no dbo.titleauthor                          user table       no      no

(1 row(s) affected)

SQL Server 7.0 will return the following:

In the current database, the specified object references the following:

name                type               updated        selected         column name -- -- --- dbo.authors          user table         no             no               au_id

Additional query words: defered

Keywords: kbbug kbpending KB201846

-

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

© Microsoft Corporation. All rights reserved.