ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rizwan Merchant" <riz...@alpha-it.com>
Subject sql task sp_dboptions problem
Date Thu, 25 Aug 2005 16:04:14 GMT
Hi,

I am trying to run an sql task which contains the following command

 

exec sp_dboption N'on_develop', N'autoclose', N'false'

 

I can run this command from SQL Query Analyzer without any problems, but
when I try to run this via ant sql task I get the following error:

 

[sql] Failed to execute:  exec sp_dboption N'on_develop', N'autoclose',
N'false'

 

BUILD FAILED

C:\workspace\build.xml:409: java.sql.SQLException: [Microsoft][SQLServer
2000 Dr

iver for JDBC][SQLServer]ALTER DATABASE statement not allowed within
multi-state

ment transaction.

 

 

Has anyone seen this before? Any help would be appreciated.

 

Thanks,

-Rizwan.


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message