How do we run a stored procedure during startup sqlserver

Question

How do we run a stored procedure during startup sqlserver

Jayakumar Krishnan

SSCarpal Tunnel

Points: 4710
More actions
January 11, 2006 at 10:26 pm

#167739

Hi Gurus,
How do we run a stored procedure while starting sqlserver from command line. If any mistake in the question itself please correct me.

thanks in advance.
warmest
Jayakumar K.
Thanks
Jay
http://www.sqldbops.com

Viewing 5 posts - 1 through 4 (of 4 total)

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

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

There is no command-line option to run a specific stored procedure. However, you can mark stored procedures in the master database to automatically start whenever SQL Server is started, not just from command-line. Use sp_procoption for this:

sp_procoption 'someprocedure', 'startup', true

The procedure cannot take any parameters and must reside in master, plus it should be owned by sa.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Jayakumar Krishnan SSCarpal Tunnel Points: 4710 More actions · Answer 2

Thank you lot Chris for your valuable tip.

Good day...

Jayakumar K.

Thanks
Jay
http://www.sqldbops.com

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 3

Sql Agent also allows jobs to be run at the start of SQL Agent.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

You can also mark multiple SP's as well. Multpile SPs are excecuted alphabetically I believe. So in order to enforce an execution order you'd have to name them accordingly.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."