> 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

why don't you just run a script?
Alan