dependencies for a table created within a stored procedure

Frederic92

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

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

Frederic92

ok thank you for your reply anyway.

Cheers,

Frederic

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

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.

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.