Re: "Display Dependencies" not showing all dependencies

From: David (spammersgohome_at_spammersgohome.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 08:59:51 GMT

So do you have a suggestion?

I would like to re-engineer a table (changing a column type), so I need to
find all objects that talk to this table.

If "Display Dependencies" does not do what it's supposed to, then what
purpose does it serve other than giving partial answers?

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uZaO$RYpEHA.1960@TK2MSFTNGP10.phx.gbl...
> Because of deferred name resolution and other factors, then you won't
> necessarily see all dependencies (e.g. depending on the order the objects
> were created). I think one way to solve would be to recompile the stored
> procedures, but I still don't think that will guarantee all dependencies
> will show up... there are other things that aren't captured by sp_depends,
> e.g. dynamic SQL.
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "David C" <nospam@nospam.com> wrote in message
> news:0oh6d.21182$OB2.1947@twister.socal.rr.com...
>> Within Sql Server Enterprise, I click on an object to show dependencies,
> and
>> there is something I am not seeing here.
>>
>> For example, I want to see all dependencies for a given table. It shows
>> a
>> view and a couple of stored procedures that perform SELECT statements.
>> However, there is a stored procedure that performs UPDATE and INSERT
> against
>> that particular table, but I am not seeing on in the Display Dependencies
>> screen.
>>
>> When I attempt to see the Dependencies screen on the stored procedure
>> that
>> does UPDATE and INSERT, I am not seeing the table listed.
>>
>> There seems to be a disconnect some place either in my head or in
> Enterprise
>> Manager. What am I missing? How can I display, all, I mean ALL
>> dependencies? For a given table, I want stored procedures listed if they
> do
>> ANYTHING on the table. And views. And functions. All dependencies,
>> period. How can I do that?
>>
>>
>
>

Relevant Pages

  • Re: Using variables in Select Statements
    ... What I am trying to do is write a recursive query to find the dependencies ... table containing the stored procedures to be checked). ... questions like yours are an indication of a design flaw. ...
    (microsoft.public.sqlserver.mseq)
  • "Display Dependencies" not showing all dependencies
    ... Within Sql Server Enterprise, I click on an object to show dependencies, and ... I want to see all dependencies for a given table. ... view and a couple of stored procedures that perform SELECT statements. ... but I am not seeing on in the Display Dependencies ...
    (microsoft.public.sqlserver.server)
  • Re: Using variables in Select Statements
    ... >What I am trying to do is write a recursive query to find the dependencies ... >dependencies table to produce a list of dependencies which need to be checked ... >table containing the stored procedures to be checked). ... you could also consider using dynamic SQL. ...
    (microsoft.public.sqlserver.mseq)
  • Table dependencies lost in Sql server 7.0!
    ... we have lost all the dependencies on a table in our development ... Stored procedures ... and Foreign keys are not working. ... About 15 other tables reference this ...
    (microsoft.public.sqlserver.server)
  • Re: "Display Dependencies" not showing all dependencies
    ... necessarily see all dependencies (e.g. depending on the order the objects ... > Within Sql Server Enterprise, I click on an object to show dependencies, ... > view and a couple of stored procedures that perform SELECT statements. ... but I am not seeing on in the Display Dependencies ...
    (microsoft.public.sqlserver.server)