audit trail

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  September 14, 2009 at 7:53 am

  #215242

  I found some good post here about audit trail and even implemented one but falls short of what I want to do. I have a 3 tier application with db on sql server. Most of the changes made to the db come from the app server. I want to set up a audit trail for every change made to the db that didnt come from app server.

  e.g. my app server is A, so I want to generate audit trail for every change where session that made the change didnt originate from server A.

  any thoughts on how to accomplish this?

  thanks

• ps.

  One Orange Chip

  Points: 29422

  More actions

  September 14, 2009 at 8:45 am

  #1053253

  Server Side Traces?

  But that would be an additional overhead on the server even to the extent of slowing down the server and even crash the database in some situations..

  Why do u need to track each and every change made to the database?

  If there are some important tables which you want to keep track of, you might want to implement tracking through triggers and storing the changes in some audit table.

  ---

  
  Pradeep Singh

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 14, 2009 at 9:13 am

  #1053275

  shahab (9/14/2009)

  ---

  I found some good post here about audit trail and even implemented one but falls short of what I want to do. I have a 3 tier application with db on sql server. Most of the changes made to the db come from the app server. I want to set up a audit trail for every change made to the db that didnt come from app server.

  e.g. my app server is A, so I want to generate audit trail for every change where session that made the change didnt originate from server A.

  any thoughts on how to accomplish this?

  thanks

  Usually that sort of audit has a negative performance hit on the server, can you break it down to what sort of activities you want to audit

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]