Add a trigger to a system table?

• Hairy Hat Man

  SSC Enthusiast

  Points: 148

  More actions

  August 13, 2003 at 2:36 am

  #81009

  I need to capture when a new database is created in a SQL 2000 instance.

  The logical thing to do would be to put an insert trigger on sysdatabases, but it is not possible to put a trigger on a system table (or a view referencing a system table).

  The solution I have arrived at is to create a table containing a copy of all the spid's from sysdatabases and compare this to sysdatabases via a scheduled job every hour or so to see if any new ones have appeared.

  Anyone got any better ideas?

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  August 13, 2003 at 5:08 am

  #469711

  What about the crdate

  Select * from Master..SysDatabases

  Where CRDate>=DateAdd(d,-1,GetDate())

• Hairy Hat Man

  SSC Enthusiast

  Points: 148

  More actions

  August 27, 2003 at 4:52 am

  #471569

  That works very nicely thank you.