ganesh

• Aug 1st, 2006

 

It can be verified by querying the common audit log where we can able to see the triggers fired.

LoniT

• Aug 1st, 2006

 

Ganesh,

can you be a little elaborate on that.

If possible using a query while explaining would be useful.

Thanks.

LoniT

 Profile Answers by LoniT Questions by LoniT

• Aug 1st, 2006

 

Ganesh,

Can you  be a little descriptive?

Thanks.

Nik_Agarwal

 Profile Answers by Nik_Agarwal Questions by Nik_Agarwal

• Sep 13th, 2006

 

I have worked on SQL, and in SQL the actions you perform on database are stored in a log file, you can go to the log file and check manually if the trigger has executed or not.

Amit Bansal

• May 9th, 2007

 

I am using SQL SERVER. In SQL SERVER, there is a tool SQL Profiler. Using SQL Profiler you wll check a trigger is fired or not. You will also check if trigger is fired then whats the output of fired trigger.

arunatrimurti

 Profile Answers by arunatrimurti 

• May 19th, 2008

 

Step 1 ) First we should know what the trigger is doing,this we discuss with development team or else tester should be able to know it with knowledge of tables or by reading the trigger in the database.

Step 2) e.g say on inserting a record ,in table 1 ,a trigger is fired which updates table 2 .
Now to test this trigger,u insert a record from front end,check its entry in table 1.Then check whether the record is updated accordingly in table2.This should be done automatically due toi trigger.If recors is updated in Table 2 that means trigger is fired else not fired.

I have not done Database testing ,but I am good at SQL so thought we can do this way,I am sure we can do it this way.If some other method is available,please do let me know.