Feature Req: Support for common table expressions (CTE)

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Feature Req: Support for common table expressions (CTE)

Postby lewismoten » Thu Mar 13, 2008 9:23 pm

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
lewismoten
 
Posts: 39
Joined: Tue Mar 28, 2006 11:39 pm

Postby Brian Donahue » Sun Mar 16, 2008 11:05 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests