From 0f842d28a116b8ff8d75787c9b17ab7fe5e61e21 Mon Sep 17 00:00:00 2001
From: Michael Trier <mtrier@gmail.com>
Date: Fri, 2 Jan 2009 18:24:47 +0000
Subject: [PATCH] Turned off the implicit transaction behavior of MSSQL.

This corrects the savepoint tests.
---
 lib/sqlalchemy/databases/mssql.py | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py
index 965cf57587..265150413f 100644
--- a/lib/sqlalchemy/databases/mssql.py
+++ b/lib/sqlalchemy/databases/mssql.py
@@ -992,6 +992,10 @@ class MSSQLDialect(default.DefaultDialect):
             newobj.dialect = self
         return newobj
 
+    def do_begin(self, connection):
+        connection.execute("SET IMPLICIT_TRANSACTIONS OFF")
+        connection.execute("BEGIN TRANSACTION")
+
     @base.connection_memoize(('dialect', 'default_schema_name'))
     def get_default_schema_name(self, connection):
         query = "SELECT user_name() as user_name;"
-- 
2.47.3