Red Gate forums :: View topic - Feature Req: Support for common table expressions (CTE)
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

Feature Req: Support for common table expressions (CTE)

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



Joined: 28 Mar 2006
Posts: 43

PostPosted: Thu Mar 13, 2008 9:23 pm    Post subject: Feature Req: Support for common table expressions (CTE) Reply with quote

I have a lot of stored procedures that appear to be orphans. I checked out all of the tables that it references, and they all exist in the diagram.

The thing that they all seem to have in common is the use of common table expressions. This was introduced with SQL Server 2005. I use these help speed up paging operations for large sets of data.

Will there be future support for this?

http://msdn2.microsoft.com/en-us/library/ms190766.aspx
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Sun Mar 16, 2008 11:05 pm    Post subject: Reply with quote

Hi Lewis,

I think this may be related to a known bug in SQL Compare. Since SQL Compare shares some components with Dependency Tracker, this should be fixed at the same time as SQL Compare.

Note that there is support for CTE in Dependency Tracker, it's only when a UDF, and I suppose this also applies to stored procedures, returns a CTE.
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