how to check what was executed during the sql server start-up ?

Question

Post reply

how to check what was executed during the sql server start-up ?

awu

SSCrazy

Points: 2037
More actions
September 30, 2008 at 5:08 pm

#131566

We can use sp_procoption to setup some SPs to run during the sql server start-up , my question is how to check what was setup on existing instances during the reboot ? Thx.
ddfg

Viewing 2 posts - 1 through 1 (of 1 total)

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

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

You can find startup procedures with this code:

use master;

select StartupProc = name

from sys.sysobjects where xtype = 'p'

and OBJECTPROPERTY(id, 'ExecIsStartup') = 1;

If you want to see them actually execute, that is a completely different story. You would have to use the ETW provider with SQL 2005, it isn't available in SQL 2000, which will allow the tracing to run through shutdown and startup of the services. Reference the following blog post from the SQL Query Processing Team:

http://blogs.msdn.com/sqlqueryprocessing/archive/2006/11/12/using-etw-for-sql-server-2005.aspx

SQL 2008 might be able to catch the startup executions with Extended Events. I haven't tested that but I certainly will now that I think about it.