Skip to content

Instantly share code, notes, and snippets.

@nanoDBA
Created January 10, 2018 18:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nanoDBA/dfe29e7635a20b7c56bafacd6ad09bad to your computer and use it in GitHub Desktop.
Save nanoDBA/dfe29e7635a20b7c56bafacd6ad09bad to your computer and use it in GitHub Desktop.
SQL Server knows your future compatiblity level... danger!
--Do you really reallly want to run this?
DECLARE @highestcompatlevel TINYINT,
@dbname NVARCHAR(128),
@sql NVARCHAR(400);
SELECT @highestcompatlevel = MAX(compatibility_level)
FROM sys.databases;
SELECT @dbname = DB_NAME();
SELECT @sql = 'ALTER DATABASE [' + @dbname + '] set compatibility_level = ' + CAST(@highestcompatlevel AS NVARCHAR(3));
PRINT @sql;
--Do you really reallly want to run this?
--EXECUTE sp_executesql @sql
@nanoDBA
Copy link
Author

nanoDBA commented Jan 10, 2018

Okay - max isn't really the future.
But it could be the future of your current database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment