Sunday, December 9, 2012

How To Check What StartUp Procedures Are We Running

The beauty of the SQL Server start-up procedure is, it will run whenever the SQL Server starts, the start-up procedures are configured depends on the environment for example in one environment some tables have to be created on tempdb for successfully functioning of the application whenever the SQL Server starts the clean tempdb will create all the time for this we need to execute some procedures as per the application, In this scenario the start-up procedure is very helpful. Click here if you want to know how to run a stored procedure automatically when SQL Server start-up?

Here is the script to finding the Start-up procedures. 

Select OBJECTPROPERTY (OBJECT_ID, 'ExecIsStartup'), *
From sys.objects
Where TYPE IN ('X', 'P', 'PC')
AND OBJECTPROPERTY (OBJECT_ID, 'ExecISStartup') = 1


Script to CHECK Startup procedures in SQL Server. Automatically Running Stored Procedures at SQL Server Startup. How to run a stored procedure at SQL Server start-up. Automatic Execution of Stored Procedures. Find Startup procedures in an instance which are automatically running. How to check sql Server 2005 startup procedure. How to check sql Server 2008 R2 startup procedure. How to check sql Server 2012 startup procedure. Audit startup procedures in SQL Server. SQL Server Startup Stored Procedure. sql server check procedure exists. how to view stored procedures in sql server

0 comments:

Post a Comment