title: pyodbc error creating tables in SQL Server
body: <pre><code>import pyodbc
  con = pyodbc.connect(connection_string) #connection_string already defined. con works
  cur = con.cursor()
  cur.execute("CREATE TABLE [schema].[TestTestTest](testcolumn1 int, testcolumn2 int)")
  con.commit() #I've also tried cur.commit()
  </code></pre>
  
  <p>The error points to line 4 with the description:</p>
  
  <pre><code>ProgrammingError: ('42000', '[42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]111212;Operation cannot be performed within a transaction. (111212) (SQLExecDirectW)')
  </code></pre>
  
  <p>Any ideas? Can we not create tables with pyodbc?</p>