Re: Trigger on D3 DM tables

On Oct 2, 7:47 am, dtsig <dt...@xxxxxxxxxxx> wrote:
Has anyone here put a trigger on DM tables? Specifically looking at
RUNTIME-ERRORS. I would like a trigger on this table so that an email
is sent to the appropriate QC person for specified errors.

The logic for the trigger is no biggie but my wonder is 'where' it
will be executed. If I am in account JOE with a qpointer to RUNTIME-
ERRORS and cause a runtime error .. will a trigger on a DM table
actually fire (it should)? Who will own the process (i expect JOE)?

Have worked out these issues in other accounts just want some insight
before I start messing with DM tables (especially something like
RUNTIME-ERRORS which might cause me a 'circular logic' error).

Account ACCT has a table ACCOUNTS which has a trigger on data portion.
Account USER has a qpointer to ACCOUNTS. When it writes it will run
the trigger in USER session.

My guess is it is the same .. just wanted to see if anyone has done
this AND that it is the same. I can always bring our system to its
knees as a test <G>

Thanks

Further reason for the question .. I have an account that does not
have a pointer to RUNTIME-ERRORS but errors in that account do get
posted. This is what is making me wonder on the process.

thanks

.

Relevant Pages

  • Re: Trigger on D3 DM tables
    ... I would like a trigger on this table so that an email ... If I am in account JOE with a qpointer to RUNTIME- ... RUNTIME-ERRORS which might cause me a 'circular logic' error). ... Account USER has a qpointer to ACCOUNTS. ...
    (comp.databases.pick)
  • Trigger on D3 DM tables
    ... Has anyone here put a trigger on DM tables? ... RUNTIME-ERRORS which might cause me a 'circular logic' error). ... Account ACCT has a table ACCOUNTS which has a trigger on data portion. ... Account USER has a qpointer to ACCOUNTS. ...
    (comp.databases.pick)
  • Re: Trigger on D3 DM tables
    ... RUNTIME-ERRORS in DM. ... The logic for the trigger is no biggie but my wonder is 'where' it ... If I am in account JOE with a qpointer to RUNTIME- ... Account USER has a qpointer to ACCOUNTS. ...
    (comp.databases.pick)
  • Re: Triggers - Inserted and Deleted Tables
    ... If you have a DML statement that affects more than one row, ... trigger will fail - I mean, you won't get an error, but the trigger action ... SELECT @OldBalance = Balance ... and I update an account holders checking and savings account. ...
    (microsoft.public.sqlserver.programming)
  • Re: call to xp_cmdshell from trigger problem
    ... I'll look this over maybe there is something we missed in the vbs script ... >> account. ... >> script that is called by the trigger the client get nothing. ...
    (microsoft.public.sqlserver.server)