We want to use Redgate continuous automation tool to continuously deploy changes done to the database.
The build is generated without any issues if we are not using JSON functions in the procedure.
Sample code in the procedure -
begin
select(select * from x for json path) as data
end;
go
When "for json path" is not used the build is generated successfully.
Should some plugin be installed so that Redgate tool processes json functions?
What is the fix to be applied?