Hi 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 quoteHide quote

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 quoteHide quote

stop using dynamic sql
how to write extended stored procedure to generate sequences.
UDT, what's the point?
How to use getdate() and user_name() functions with Windows NT login
No transaction is active
Compatibility level, SQL 2005
Cursor doesn't loop properly???
create function
Number of days in previous quarter?
What is wrong with this code?