From: nsubbu1986@gmail.com   
      
   Hi Experts,   
   here onwards i will some qs regarding only for sqldba.can anyone clarify and   
   suggest to me plz   
      
   I have two databases, based on first db execution sucessful move to   
   second, upon second db execution scucessful.. commit the   
   transaction..if anything fail roll back transaction from both dbs   
      
   Example: DB1 and DB2   
   DB1 has Dept and DB2 has Employee...   
   now if dept and Employee data successfull then commit data in both DBs   
   else rollback from both DBs..   
      
   Please help me how to handle this?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)