Post reply

Reset Sequences

  • December 12, 2019 at 4:59 pm

    #3707464

    hi,

    what are the best procedure to automate the  reset of a sequence every  midnight.

     

  • 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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply