List all Stored Procedures set to Automatically Run at SQL Server Startup

To list all Stored Procedures that are set to automatically execute at SQL Server startup, run the following query:

SELECT name, type_desc, create_date, modify_date
FROM sys.procedures
WHERE is_auto_executed = 1

If there are Stored Procedures set to automatically run at SQL Server startup, the query result will give you their name, type description, create and modify name:

sp_auto_execute_list

To see how to Configure Stored Procedures to Automatically Run at SQL Server Startup, read related article:
Configure Stored Procedures to Automatically Run at SQL Server Startup

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">