December 18, 2003 at 1:21 pm
Is there a way to trigger a stored procedure based on the startup and shutdown of sql server?
I want to start saving my SQL Log files for something like... forever. While I could just archive them on some set basis I would rather archive them whenever SQL Server restarts and creates a new one.
It'd be nice if SQL Server had some way to trigger an event based on the startup or shutdown of the service. Ideas?
Is this some basic functionality that I am foolishly unaware of that is simply called something else?
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
December 18, 2003 at 1:30 pm
Use sp_procoption to set sp to autoexection runs every time SQL Server is started.
December 18, 2003 at 1:32 pm
You rock, man!
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply