How can we help you today? How can we help you today?

dependencies for a table created within a stored procedure

hello,

It is probably a newbie question so apologies for that but I could not find any answer in the forum.

I have a stored procedure MySP that creates a table; something like
"select * into NewTable from SourceTable"

and I'd like to have a diagram showing dependencies like:

* MySP depends on table "SourceTable" - this one is working fine
* NewTable depends on MySP - this one does not work

I think this is due to a limitation in SQL server as explained here : http://msdn.microsoft.com/en-us/library/ms345449.aspx

but I wonder if someone has encountered similar limitation and fixed it ?

Thanks for your feeback,

Frederic
Frederic92
0

Comments

5 comments

Sort by
  • peter.peart
    We use a separate dependency checking mechanism than SQL Server, however to the best of my knowledge, this isn't supported in the tool which is why it wouldn't be working for you.

    I'm also very sorry to say that I'm not aware of any workaround at all. I'll raise it as a feature request for you though to see if we can support this.

    Pete
    peter.peart
    0
  • Frederic92
    ok thank you for your reply anyway.

    Cheers,

    Frederic
    Frederic92
    0
  • POTOOLE
    Hi Pete

    Can you confirm if this has been added as a feature request?

    Thanks

    Paul

    peter.peart wrote:
    We use a separate dependency checking mechanism than SQL Server, however to the best of my knowledge, this isn't supported in the tool which is why it wouldn't be working for you.

    I'm also very sorry to say that I'm not aware of any workaround at all. I'll raise it as a feature request for you though to see if we can support this.

    Pete
    POTOOLE
    0
  • Blambers
    Sorry about the Necro, but this still doesn't seem to be supported by SQL Dependency Tracker, Smart Rename or SQL Doc. If a table is created by a "SELECT INTO"  type statement, this should really be captured in the dependency tree.
    Blambers
    0
  • Dan B
    Hi Blambers,

    Whilst we did create a feature request for this we have taken the decision not add this feature to the product. Work is continuing on issues but the decision has been made that this issue is not a necessary addition at this time and there isn't enough demand to add it.

    The feature request remains open so this can be reviewed in the future.

    Dan B
    0

Add comment

Please sign in to leave a comment.