Thursday 29 February 2024
SQL Query to Find Client(session) Oracle Driver Version
select SID, AUTHENTICATION_TYPE, CLIENT_VERSION, CLIENT_DRIVER from v$session_connect_info;
Tuesday 6 February 2024
Changing Sql Server Compatibility Level
The compatibility level for a database can be changed very easily using the ALTER DATABASE statement. Here is the basic syntax:
ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = version;
For example, to change a database named ‘devdb’ to the SQL Server 2022 compatibility level:
ALTER DATABASE devdb SET COMPATIBILITY_LEVEL = 160;
Subscribe to:
Posts (Atom)