Stored Procedure script to show startup Procs

USE [master]
GO

CREATE proc [dbo].[sp_ShowStartupProcs]
as
SELECT *
FROM [sysobjects]
WHERE [type] = ‘P’ AND OBJECTPROPERTY(id, ‘ExecIsStartUp’) = 1;

GO

Advertisements

Author: Protiguous

C# Software Developer, Father, and seeker of Truth.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s