SSDT error SQL71526 on stored procedure.

- SqlPackage or DacFx Version:
//////////////////////////////////////////////////////////
Microsoft Visual Studio Community 2022
Version 17.9.0
VisualStudio.17.Release/17.9.0+34607.119
Microsoft .NET Framework
Version 4.8.04161

SQL Server Data Tools 17.9.51.1
Microsoft SQL Server Data Tools
//////////////////////////////////////////////////////////

**Steps to Reproduce:**

There is a stored procedure which is working fine on SSMS.
But same stored procedure is failing with below error in SSDT ;

SQL71526: A table that has a defined column set can have up to 30,000 columns with a maximum of 1024 non-sparse and computed columns. Tables that do not have column sets are limited to 1024 columns.


The line number highlighted in the message corresponds to a CTE in this SP. (which only has 10 columns ).
If we expand the asterisk (*) in the select list of this CTE to column names , the issue disappears.

(DacFx/SSDT)

Start by reproducing the SSDT SQL71526 diagnostic with the stored procedure and its CTE containing SELECT *. Compare the result with the version that expands the CTE's columns explicitly, using the reported SSDT 17.9.51.1 environment. Done means explaining or correcting the false diagnostic without requiring the workaround.

Written by the indexing model from the issue text.