Feature Req: Support for common table expressions (CTE)

[lewismoten]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521