Wednesday, 26 March 2025

How to change all DB's compatibility level at a time


USE [master]

GO

select 'ALTER DATABASE ['+name+'] SET COMPATIBILITY_LEVEL = 130' from sys.databases where database_id > 4

No comments:

Post a Comment

To Shrink Tempdb