|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Startup stored proceduresHi all
i need to write script that check if there is any 'Startup stored procedures ' , how i write it? Thanks 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 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 |
|||||||||||||||||||||||