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
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569

[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