RE: sql task sp_dboptions problem

2005-08-25 Thread RADEMAKERS Tanguy
/t >-Original Message- >From: Rizwan Merchant [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 25, 2005 9:28 PM >To: 'Ant Users List' >Subject: RE: sql task sp_dboptions problem > >Hmmm...that looks like a good idea. Thanks... > >-Original Messag

RE: sql task sp_dboptions problem

2005-08-25 Thread Rizwan Merchant
Hmmm...that looks like a good idea. Thanks... -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 3:06 PM To: Ant Users List Subject: RE: sql task sp_dboptions problem we... (more than one way to skin a cat) if the

RE: sql task sp_dboptions problem

2005-08-25 Thread RADEMAKERS Tanguy
ng about selectively executing only some parts of the file, but it would get messy quite quick! /t >-Original Message- >From: Rizwan Merchant [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 25, 2005 9:00 PM >To: 'Ant Users List' >Subject: RE: sql task sp_dboptio

RE: sql task sp_dboptions problem

2005-08-25 Thread Rizwan Merchant
2005 2:51 PM To: Ant Users List Subject: RE: sql task sp_dboptions problem wouldn't this work? >-Original Message- >From: Moran Ben-David [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 25, 2005 8:43 PM >To: 'Ant Users List' >Subject: RE: sql task s

RE: sql task sp_dboptions problem

2005-08-25 Thread RADEMAKERS Tanguy
wouldn't this work? >-Original Message- >From: Moran Ben-David [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 25, 2005 8:43 PM >To: 'Ant Users List' >Subject: RE: sql task sp_dboptions problem > >Sorry Razwan, > >I am not familiar w

RE: sql task sp_dboptions problem

2005-08-25 Thread Rizwan Merchant
... -Original Message- From: Moran Ben-David [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 2:43 PM To: 'Ant Users List' Subject: RE: sql task sp_dboptions problem Sorry Razwan, I am not familiar with the task enough to help you on that. However, one thing I can suggest is th

RE: sql task sp_dboptions problem

2005-08-25 Thread Moran Ben-David
DROP DATABASE ${the.database.i.wanted.to.pass}; Moran > -Original Message- > From: Rizwan Merchant [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 25, 2005 1:47 PM > To: 'Ant Users List' > Subject: RE: sql task sp_dboptions problem > > > Hi Moran,

RE: sql task sp_dboptions problem

2005-08-25 Thread Rizwan Merchant
From: Moran Ben-David [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 12:14 PM To: 'Ant Users List' Subject: RE: sql task sp_dboptions problem Sounds like you're issue is with the SQL Server connection properties. Query Analyzer tends to have different defaults for the con

RE: sql task sp_dboptions problem

2005-08-25 Thread Moran Ben-David
like set AutoCommit on or something like that. moran > -Original Message- > From: Rizwan Merchant [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 25, 2005 12:04 PM > To: Ant Users List > Subject: sql task sp_dboptions problem > > Hi, > > I am trying to run a

sql task sp_dboptions problem

2005-08-25 Thread Rizwan Merchant
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 exe