Unable to generate execution plan for TSQL batch using SQL statements with "Out Parameter"
説明
The TSQL batch where the affected query is being run appears to be a dynamic SQL with "out parameter", executed by sp_executeSQL. When the SQL Server saves the batch text in such a scenario it is executable because "out parameter" can only be executed inside sp and not as a script (incorrect syntax ). Since the batch text syntax is incorrect Foglight failed to generate an execution plan. Foglight does not support generating an execution plan for batch with "out” parameter" executed as dynamic SQL, because of the way batch text is saved in SQL Server.