Received this error (2003-03-25 12:41:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]) executing this command in an SQLServerAgent job (SQL2K, SP3). There are only 1-10 records in each of the referenced tables so it's difficult to buy the timeout, but what's with the ODBC in SQA? Does SQA really use ODBC to manage data in a SQL2K database?!

Thanks,

Al

delete customer4RAMS
from customer4RAMS d
inner join customer2RAMS c on
c.idn=d.idn and
c.modoper=d.modoper and
c.moddate=d.moddate and
c.addoper=d.addoper and
c.adddate=d.adddate
where d.actiontype in ('J','V')