RE: Are there limits to number of INSERTS inside a Tra nsaction?

> > Now the question:  Can I do too much inside a transaction?  In other
> > words, say I was importing a file with 100,000 records and I wanted
> > to make sure either the whole thing imported or none of it; would it
> > be a bad idea to do ALL of the inserts within a single transaction?
> >
> > Are there any limits to the number of inserts/updates 
> within a transaction?
> >
> > Ken Causey
> 
> As I know all in one must work. Why not trying, you'll got 
> the answer by
> yourself ?
> If you use transaction and it failed just do an ABORT TRANSACTION...

Max # of commands per transaction is 2^32...

Vadim