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
Sounds like you're issue is with the SQL Server connection properties. Query Analyzer tends to have different defaults for the connection settings than your Ant initiated connections. Look up the error in a sql site like "www.sqlmag.com", I'm sure there will be an explanation like set AutoCommit o