Script for updating sequences with SQL Server

Question

I'm using Microsoft SQL Server 2008 R2 for a JEE Application (JSF, JPA, EclipseLink).

I restart my database weekly and doing that I need to update the sequence of all my tables like that:

UPDATE[dbo].[SEQUENCE] 
SET [SEQ_COUNT] = (SELECT MAX(IDAGENCE) 
                   FROM AGENCE) 
WHERE SEQ_NAME = 'SEQ_AGENCE'

My question is: how do I trigger a script when I restart my database to update all my sequences?

Thanks you for your help

Haven't tried it myself, but take a look at this blog post - it was the first thing to show up when I Googled for this. — 3N1GM4
– 3N1GM4, Commented Dec 20, 2016 at 8:49

Ken Keenan · Accepted Answer · 2016-12-20 08:48:59Z

5

There is a built-in stored procedure in SQL Server, sp_procoption, that lets you designate a stored procedure to run when the server restarts. You would use it like this:

EXEC sp_procoption @ProcName = 'MyProcedure', @OptionName = 'STARTUP', @OptionValue = 'ON'

answered Dec 20, 2016 at 8:48

Ken Keenan

10.7k5 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Script for updating sequences with SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related