monitoring users tables...

From: Viviana Kern (anonymous_at_discussions.microsoft.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 09:40:13 -0700

In our system we have triggers of several tables.
Last day when a worked whith system, I detected that the
trigger was not found. I executed sp_help trigger and the
objects not found.
It is possible to monitoring who user has dropped it ??
I was probeing to create a trigger for deleted in
sysobject and it was impossible.
What can I do ??
TIA

Relevant Pages

  • monitoring users tables...
    ... person that executes the drop trigger sentences, ... You had the source code in some central repository ... >>Last day when a worked whith system, ...
    (microsoft.public.sqlserver.programming)
  • monitoring users tables...
    ... The only way you can re-create a trigger is if: ... You had the source code in some central repository like ... >Last day when a worked whith system, ...
    (microsoft.public.sqlserver.programming)
  • Who may create a trigger on SYSOBJECTS table
    ... Is it possible to create a trigger on SYSOBJECT? ... I am logged on as dbo, and trying to create a trigger that executes when a ... Check if you are DBO: ...
    (microsoft.public.sqlserver.programming)
  • Re: Who may create a trigger on SYSOBJECTS table
    ... Microsoft does not support triggers on system tables. ... > Is it possible to create a trigger on SYSOBJECT? ... > 1) Check if you are DBO: ...
    (microsoft.public.sqlserver.programming)
  • Re: Who may create a trigger on SYSOBJECTS table
    ... You cant create triggers on system tables. ... > Is it possible to create a trigger on SYSOBJECT? ... > 1) Check if you are DBO: ...
    (microsoft.public.sqlserver.programming)
Loading