--- a
+++ b/tests/support/mssql/setup.sql
@@ -0,0 +1,8 @@
+CREATE DATABASE test
+ALTER DATABASE test SET COMPATIBILITY_LEVEL = 100;
+
+CREATE DATABASE temp_tables
+ALTER DATABASE temp_tables SET COMPATIBILITY_LEVEL = 100;
+
+SET QUOTED_IDENTIFIER ON;
+GO