SQL Server compatibility level DONE

17

Would be great to have it!

I can't count how many times i've bounced off the wall with the string_split :)

I would be fine with an overview which WEBCON BPS versions support which compatibility level.
Since SQL Server 2014 will be supported for one more year, I doubt that the default setting will be changed. After all not all customers use the latest version.

Of course it would be nice, if the latest supported version for the specific server would be set, but I could do it myself, if I would have the information. :)

I solved tthis problem with create another database with my settings and i made connection between my database and BPS_Content.

Hey there, this case has already been addressed in 2025.1. Here's the excerpt from the change log:

• Changed the default compatibility level for new SQL databases created during the installation of the WEBCON BPS platform. As a result, the previous compatibility level set to 120 (SQL Server 2014) has been replaced with the highest possible level, which, however, cannot exceed 160 (SQL Server 2022). This modification does not affect existing databases, which will retain their compatibility level of 120.