nrdroque
Old Hand
Points: 348
More actions
December 12, 2019 at 4:59 pm
#3707464
hi,
what are the best procedure to automate the reset of a sequence every midnight.
ScottPletcher
SSC Guru
Points: 100942
December 12, 2019 at 6:04 pm
#3707476
Issue an ALTER SEQUENCE statement with the change(s) you want to make.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply