Our security team is flagging the gtrep database for running in SQL Server 2008 compatibility mode. We can see one of the first lines of the gtrep setup script is explicitly forcing this via this command:
ALTER DATABASE [gtrep] SET COMPATIBILITY_LEVEL = 100
Can you provide any input to why this is set to SQL 2008 (level 100)? Is there something that would break by changing this to SQL 2019 (level 150)?
TDM 4.10
N/A
SQL Server 2008 is not supported with TDM 4.10. Refer to this documentation for supported databases for GTREP:
SQL Server 2019 is a supported database for this TDM Release.
100 is the lowest level, so having greater than that would be ok.