RE: How to check a trigger is fired or not,while doing...
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.
RE: How to check a trigger is fired or not,while doing...
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.
RE: How to check a trigger is fired or not,while doing Database testing?
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.
