A script that runs when SQL Server is started... 1

[yakata]

Hi there,

I'm just looking for a way to 'auto' execute a stored proc when a sql server is started on my server...
Actually, I need that this sp is executed BEFORE any other command or transaction is commited to the server... SQL 2000
Any Idea ?

TIA for a reply

 

[ClaireHCM]

From BOL:

sp_procoption
@ProcName = 'ProcName'
,@OptionName = 'Startup'
,@OptionValue = 'True'

Execute permissions default to members of the sysadmin fixed server roles.

Startup procedures must be owned by the database owner in the master database.

 

[yakata]

Cool, ClaireHsu

Exactly what I nedd, have a great day !)

Thanks