Hi,

I have a stored procedure that I use to empty out tables and set up an
empty Database.

Is there any way of setting generator values (to 0) in a stored procedure?

Dropping and recreating the DB every time I want to reset it is a REAL pain
in the neck ...

And so is dropping and recreating the generators, tables, and associated
triggers.

Regards

Tim