Automatic Creation and Modification log

[Phino]

Hi there,

I need some help in order to reduce the amount of code needed to
implement the logging of INSERT and UPDATE in my application's
database.

In every table of my database I have four fields (CreatedBy,
CreatedTime, ModifiedBy, ModificatedTime), these fields allow me to
trace the users who create and modify the registers in my application.
I know that I can add in every stored procedure a piece of code who
uses the app user as a parameter, and insert these information in the
register. But I would like to go beyond these method. I imagine there
is a better way of doing it, and I don't like to use triggers. Is
there any method, within the SQLServer functionality, that allows me
to automate this process?

So, any help would be very appreciated!!
Thank you very much in advance!

[Steve Troxell]

Phino wrote:

I imagine there is a better way of doing it, and I don't like to use
triggers. Is
there any method, within the SQLServer functionality, that allows me
to automate this process?

Yeah, triggers.

--
Steve Troxell