Competition: What’s your favorite Redgate tool? Enter now.

Feature Req: Support for common table expressions (CTE)

lewismotenlewismoten Posts: 58
edited March 16, 2008 6:05PM in SQL Dependency Tracker
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
Sign In or Register to comment.