Re: Trigger does not seem to fire from front end or enterprise manager

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 17:32:33 +0100

No, that should not happen. Are you certain that it isn't a view you are
working against?

To see what really happens, I suggest that you run a profiler trace to see
what SQL EM submits. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Keith G Hicks" <krh@comcast.net> wrote in message
news:%23EwXwxOEEHA.3716@TK2MSFTNGP10.phx.gbl...
> Please do not yell at me for not being more specific.  I am having a
problem
> with a trigger and will get more specific if necessary.
>
> In general is there a reason why a trigger would fire properly when doing
an
> update statement on a table from the query analyzer but seemingly NOT fire
> at all when making a change to a field in the enterprise manager?
>
> Thanks,
>
> Keith
>
>

Relevant Pages

  • Re: Update Trigger
    ... Include an Update statement inside the same trigger to update the column in ... Hari ... SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Use INSERTED and DELETED in SP
    ... > an "universal History Trigger". ... inserted or deleted data) into one HISTORY table. ... > should be a somehow transaction log, ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Auto truncate a string to be inserted to SQL table
    ... Tibor Karaszi, SQL Server MVP ... The trigger is merely used to call another ... > stored procedure to validate the record against predefined business rule. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: insert and update in trigger
    ... Tibor Karaszi, SQL Server MVP ... > If I define the trigger on update and insert only, ... >> An insert statement can insert a single row, or with an INSERT/SELECT, it ... >>>> Kalen Delaney ...
    (microsoft.public.sqlserver.server)
  • Re: Auto truncate a string to be inserted to SQL table
    ... So the error is generated from the INSERT statement which then fires the trigger? ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ... The app will insert record to SQL table at the ...
    (microsoft.public.sqlserver.programming)