dependencies for a table created within a stored procedure

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

dependencies for a table created within a stored procedure

Postby Frederic92 » Wed Jan 18, 2012 4:56 pm

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
 
Posts: 2
Joined: Wed Jan 18, 2012 4:35 pm

Postby peter.peart » Fri Jan 20, 2012 6:19 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby Frederic92 » Fri Jan 20, 2012 6:26 pm

ok thank you for your reply anyway.

Cheers,

Frederic
Frederic92
 
Posts: 2
Joined: Wed Jan 18, 2012 4:35 pm

Re:

Postby POTOOLE » Thu May 09, 2013 9:24 am

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
 
Posts: 2
Joined: Thu May 09, 2013 9:10 am
Location: Dublin, Ireland


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests