SQL Server Performance

Startup Stored Procedure

Discussion in 'SQL Server 2005 General Developer Questions' started by gujsa01, Oct 8, 2007.

  1. gujsa01 New Member

    Hi,
    Is there a way to identify Startup Stored Procedures??
    Appreciate any help and thanks in advance.
  2. MohammedU New Member

    select routine_name,
    objectproperty(object_id(routine_name),'execisstartup')
    from information_schema.routines
    where routine_type = 'procedure'
    and objectproperty(object_id(routine_name),'execisstartup') = 1

Share This Page