Joseph Pellicano wrote:

>>As long as you realise that CURRENT_TRANSACTION, if stored, won't be
>>unique in the lifetime of the database.

> I am quite happy with that, but will it be unique for SQL statements
> executed in the same transaction? I am assuming that it will be.

Yes.

The CURRENT_TRANSACTION resets after a database restore. Restoring a
database backed up with GBAK actually recreates the database, and stores
all records in the same transaction (usually, depending on switches) so
after a backup/restore, your stored transaction ids will be of
historical interest only.


Regards,


Ann