469,167 Members | 1,140 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Automatic Creation and Modification log

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!
Jul 20 '05 #1
1 1103
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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Matt Traxinger | last post: by
3 posts views Thread by Ido | last post: by
2 posts views Thread by Jeremy | last post: by
1 post views Thread by klimmass | last post: by
3 posts views Thread by tkpmep | last post: by
58 posts views Thread by Jorge Peixoto de Morais Neto | last post: by
2 posts views Thread by =?Utf-8?B?UmV5bm9sZHNVc2Vy?= | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.