468,115 Members | 2,097 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Where to create application logs from?

I need to create application logs where everything that is done is logged to
some sort of storage space (sql, xml, or whatever). The log would be used to
track activities in the admin control pannel of the website. Examples would
be Adding, editing and deleting news, events, signing in/out and so on.
Should I be doing this at the sql server level or should I be doing this at
the application level. I have an sql error log in the database (at the
database level) that requires a person to actually log into the server to
see the errors logged into the table. Should I consider making this
available in the application as well?

Oct 29 '08 #1
1 935
On Wed, 29 Oct 2008 15:04:32 +0100, Andy B <a_*****@sbcglobal.netwrote:
Should I be doing this at the sql server level or should I be doing this
at the application level.
It really depends on what you a trying to solve. If you need to log only
database activity you will propably want to do some research on Sql Server
auditing, and you should be able to find some "automagic" way of logging
everything in the database:

http://www.google.com/search?hl=en&q...erver+auditing

If you, on the other hand, want some more specilized logging scheme where
you explicitly define what to be logged and when to log it, it might be
better to implement the logging at the application side. Have a look at
the libraries "log4net" and "nlog" if you want to do application side
logging.

--
Joern Schou-Rode
http://malamute.dk/
Oct 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Russell E. Owen | last post: by
reply views Thread by Gianluca_Venezia | last post: by
2 posts views Thread by Keith Jakobs, MCP | last post: by
18 posts views Thread by jabailo | last post: by
9 posts views Thread by Marc Miller | last post: by
9 posts views Thread by Steve Buster | last post: by
4 posts views Thread by Mike Schilling | last post: by
5 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.