Automatic Execution of a Stored Proceedure

How do you set a stored proceedure for automatic execution?

--
Message posted via http://www.sqlmonster.comIf you mean execute it at a certain time, then you can create a
scheduled job to run it at that time - "Scheduling Jobs" in Books
Online. If you want to run a proc automatically when MSSQL starts, see
"Automatic Execution of Stored Procedures" and sp_procoption.

Simon