Finding no.of triggers in a database

• cutespn

  SSCommitted

  Points: 1669

  More actions

  April 3, 2003 at 2:24 am

  #81301

  hi,

  how can i find the no.of triggers in a particular database.

  thnks in advance.

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  April 3, 2003 at 3:33 am

  #452975

  select count(*)

  from sysobjects

  where xtype = 'TR'

  Jeremy

• cutespn

  SSCommitted

  Points: 1669

  More actions

  April 3, 2003 at 9:01 pm

  #453127

  hi,

  thnx for the help.

  rgrds,

  sudheer

  
  
  
  
  
  

  Regards,
  Sudheer