Hi Jeff ,

Sure 🙂

I got little confused on the last question asked by David..

I am on my way to office and will try your suggestion and post my query here...

Hi Jeff,

Please explain how to create a Reporting view for Auditing using Employee table and Employee Audit Table.

Thanks

Hi Jeff,

Is...

Hi Jeff,

Sure ..... 🙂

I am going to implement this and will let you know the status shortly .....

Hi Jeff ....

Understood 🙂

Thanks very much again ....

Hi Jeff ,

Thank you very much Jeff ...!!! 🙂

Your explanation clearly clarified all the doubts I had ....

This experience will help me in the long run .....

I will implement all...

Hi Jeff,

Please spare me, im asking same doubt again, :unsure:

Im doing the testing of the new trigger without adding new Column. I found the following .

1. During an Update...

Hi Jeff,

Adding to my previous doubt, to be more precise my doubt is.

1. Can I implement the new trigger which you wrote without adding extra column ?

2. If I implement...

Hi Jeff,

Thanks again for clarifying my Doubts.... 🙂

No Jeff, It suffers...

Im sorry That is My Mistake, I was trying to create the table in test environment and...

Hi Jeff,

Sorry for the late reply, I took some time to find out things you asked...

I also come up with doubts regarding the things you said,

Please spare me if...

Hi Jeff,

Thanks very much again 🙂

Please give me some time today ... I will thoroughly analyze the full scope of this table and post shortly...

Hi Jeff

Can I try the trigger without modifying my table since they already have a created on and user id columns

Please advise...

Hi Jeff,

This trigger assumes that the Employee table and the EmployeeAudit table have both been modified by adding a

"CreatedOn" DATETIME column that defaults to GETDATE() and a "CreatedBy"...

Hi Jeff,

No problem 🙂 thanks very much for looking into it 🙂