I have a table called employee with records as
where my EMPID is primary key.
When I try to insert a new record with EMPID as 3 using TRIGGER. What will LOG file hold?
Please help me out, ping me back if question is not clear?
A trigger won't affect what goes into the log. If you're manipulating data, a log entry is created, whether that's from a procedure or a trigger.
Maybe I don't understand the question.
answered May 03 '10 at 11:47 AM
Grant Fritchey ♦♦
As Grant said, a trigger will not directly affect what goes into the log. If the trigger itself contains a logged command that will go in the log as normal.
One other thing I would note, I would expect a column named empid to have a unique index (perhaps primary key?) and it looks like you already have a #3 there. So if you tried to insert it, it might be rejected with a duplicate error.
answered May 03 '10 at 01:35 PM