Hi Mark, On Thu, 2010-03-18 at 14:29 +0000, markscottwri...@gmail.com wrote: > I'm trying to get SQL Server 2005 to CREATE DATABASE using twisted. > However, SQL Server won't allow you to run CREATE DATABASE within a > transaction (apparently, it's not something sql server can roll back, > which seems sensible). Which means that the following code results in > an error. Is there a way to turn transactions off for a query?
First, you may be better off finding a SQL Server list. FWIW, and not a twisted solution per se, if the SQL server and your twisted server are in a secured network you can send an http msg with your create database statement. This solution requires a webserver (IIS) running on the sql server box and some configuration (a virtual directory IIRC). This solution will work from a non-windows OS. For more complicated queries, taking the ODBC black box out of the equation makes optimization simpler (or even possible). LMA (Luvin my acronyms). George -- George Pauly Ring Development www.ringdevelopment.com _______________________________________________ Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
