|Subject||Re: Copying one database to another|
> IPerhaps your transactions are started before the original table data
> don't understand why these preceeding tables act like they're
> receiving data but end up empty when the first table copies correctly.
> I'm using a procedure where I pass a table name and copy all records
> and all fields to the target table. I'm thinking that, if my
> procedure was flawed, the first table processed wouldn't be getting
> any data.
> Any ideas?
is committed. If this is the case, your transaction wont see the data
inserted by the other transaction.