Hot to detect MSSQL trigger

Hot to detect MSSQL trigger

Post by lsg » Tue, 13 Jun 2006 12:36:56



Hi,
I don't know which newsgroup should i refer to. If anyone know
how to solve my problem pls help me. tks.
I need to know how to detect a trigger action has been perform
in a MSSQL table(eg. abc). where abc is a table for program
abc. but i need to write a program to detect the changes
(Insert, Delete, or Update) of the table. Someone told me that
i can use the trigger to do so. but i have no idea how to do
it. Does anyone know any web site that i can refer to where i
can find example or info how to do it? Thanks in advance.


lsg
 
 
 

Hot to detect MSSQL trigger

Post by Darre » Tue, 13 Jun 2006 22:41:55

Basically it is just an event procedure assigned to a server dataset.

The trigger happens server side. You need to create it using Enterprise
Manager or some other utility.

 
 
 

Hot to detect MSSQL trigger

Post by lsg » Tue, 13 Jun 2006 23:31:26


Hi,
How do i link it with Delphi? i mean how can Delphi program
receive those "affected" records from the trigger that happen
to the table? OR do i need to create a table to store this
data and then I have retrieved those data from the Delphi program?

Tks a lot.

lsg