Re: Creating an AFTER AFTER trigger

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 12:14:20 -0500

More detail, please?

Your view will reflect the new values, assuming it queries one of the tables
you've modified in the trigger.... 

-- 
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Ian Boyd" <ian.msnews010@avatopia.com> wrote in message
news:exFeJGZ%23EHA.3236@TK2MSFTNGP15.phx.gbl...
> i want a trigger to fire after the data modification has been applied to
the
> database - so that a view i query from contains the new values.
>
> Possible?
>
> Short of having the trigger start a scheduled task.
>
>

Relevant Pages

  • Re: Performance and second table
    ... There is lot of evaluations ... SQL Server doesn't know that the data in both tables is ... down because the trigger has to be executed. ... keeping other queries blocked for longer ...
    (comp.databases.ms-sqlserver)
  • Re: update statement not to fire trigger
    ... > I have a trigger on UPDATE on a table. ... > UPDATE and DELETE queries which I want the trigger to ignore but at the ... Before you run your maintenance operation, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: update statement not to fire trigger
    ... > I have a trigger on UPDATE on a table. ... > UPDATE and DELETE queries which I want the trigger to ignore but at the ... ALTER TABLE tbl DISABLE TRIGGER ALL ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Sending a message from a trigger
    ... I have a SQL Server 2000 back end and a VB6 front end and I would like the ... Right now I have a timer that queries the table every 5 ... but I would like to create a trigger instead and send a message to ...
    (microsoft.public.sqlserver.programming)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)