Startup stored procedures

microsoft.public.sqlserver.programming

9 Jun 2006 4:23 PM

imss

Hi all
i need to write script that check if there is any 'Startup stored
procedures ' , how i write it?
Thanks

9 Jun 2006 4:27 PM

SQL Menace

Here is one way

SELECT name FROM sysobjects
WHERE xtype = 'p'
AND OBJECTPROPERTY(id, 'ExecIsStartup') = 1

Denis the SQL Menace
http://sqlservercode.blogspot.com/

i***@netvision.net.il wrote:
Show quote

> Hi all
> i need to write script that check if there is any 'Startup stored
> procedures ' , how i write it?
> Thanks

9 Jun 2006 4:53 PM

Tracy McKibben

SELECT sysjobs.name
FROM msdb..sysjobs sysjobs
INNER JOIN msdb..sysjobschedules sysjobschedules
ON sysjobs.job_id = sysjobschedules.job_id
WHERE sysjobschedules.freq_type = 64

i***@netvision.net.il wrote:
Show quote

> Hi all
> i need to write script that check if there is any 'Startup stored
> procedures ' , how i write it?
> Thanks