Transactions is used for rollback (if it is necessary) actions in one connection and for separate actions between connections (uncommited actions are invisible (in most cases) for other connections). I'm not sure you can put in the same transaction actions in separate connections at all.
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...
