CREATE DATABASE inside a transaction with Microsoft SQL 2005
- From: zunilp@xxxxxxxxx
- Date: 30 May 2006 01:20:11 -0700
Hi,
Till now I am using SQL server 2000 with Microsoft JDBC SP3 for 2000.
Everything is fine.
But now I moved to SQLServer 2005 with Microsoft JDBC for 2005. But it
throws
an error "CREATE DATABASE statement not allowed within multi-statement
transaction" when our application tries to create a new DB inside a
transaction. All other DDL statements like CREATE TABLE, ALTER etc
works well inside a transaction with JDBC. We found that only CREATE
DATABASE has problem.
This problem is not there with Old JDBC driver with SQL 2000.
I know such a problem is there with SYBASE in which by default sybase
wn't allow DDL statements inside a transaction. But they provide an
option DDL_IN_TRAN or something like that. Enabling this will allow
DDL.
How I can make CREATE DATBASE work inside a transaction. Is there any
options available.
Regards
zunilp
Cordys
.
- Prev by Date: RE: Using alias in url to connect to database server
- Next by Date: RE: when is [hotfix for KB article 917054] going to release?
- Previous by thread: RE: The FOR XML clause is not allowed in a CURSOR statement
- Next by thread: RE: when is [hotfix for KB article 917054] going to release?
- Index(es):
Relevant Pages
|
