Red Gate forums :: View topic - dependencies for a table created within a stored procedure
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

dependencies for a table created within a stored procedure

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Frederic92



Joined: 18 Jan 2012
Posts: 2

PostPosted: Wed Jan 18, 2012 4:56 pm    Post subject: dependencies for a table created within a stored procedure Reply with quote

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
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Jan 20, 2012 6:19 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Frederic92



Joined: 18 Jan 2012
Posts: 2

PostPosted: Fri Jan 20, 2012 6:26 pm    Post subject: Reply with quote

ok thank you for your reply anyway.

Cheers,

Frederic
Back to top
View user's profile Send private message
POTOOLE



Joined: 09 May 2013
Posts: 2
Location: Dublin, Ireland

PostPosted: Thu May 09, 2013 9:24 am    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group