This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script for finding the list of Startup Procedures in SQL Server.
The startup procedure is useful if you have operations that you want to perform regularly, or if you have a stored procedure that runs as a background process and is expected to be running at all times.
For example: When SQL Start, we can create a global temp tables in TempDB.
Below is a script for getting the list of configured startup stored procedures:
|
1 2 3 4 |
SELECT name FROM sys.objects WHERE type = 'P' AND OBJECTPROPERTY(object_id, 'ExecIsStartup') = 1 |
Leave a Reply