|
Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to find names of stored procedures scheduled for execution upon server start.
USE AdventureWorks2008;
SELECT StartupSproc = name
FROM sys.sysobjects
WHERE xtype = 'p'
and OBJECTPROPERTY(id, 'ExecIsStartup') = 1;
Related article link: Automatic Execution of Stored Procedures
http://msdn.microsoft.com/en-us/library/ms191129.aspx
|
