|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Records Versioning/AuditingHowdy,
Forgive me if this is the wrong group. I'm writing a ASP.Net application and i need to track every change to a table's records. In SQL 2005, is there a way to easily keep a record change history? Something with rules or triggers or something? Or am I stuck comparing every field manually before i perform the UPDATE? Thanks a lot! A trigger can do what you need (i.e. putting a changed record into an audit
table prior to or after an update). I recommend checking out ApexSQL's Audit. It can set up everything for you with a mostly point-and-click interface. -- Show quoteKevin G. Boles TheSQLGuru Indicium Resources, Inc. "David Lozzi" <dlozzi(remove-th***@delphi-ts.com> wrote in message news:136C1D21-F4AD-4F15-B193-732576A972EA@microsoft.com... > Howdy, > > Forgive me if this is the wrong group. I'm writing a ASP.Net application > and > i need to track every change to a table's records. In SQL 2005, is there a > way to easily keep a record change history? Something with rules or > triggers > or something? Or am I stuck comparing every field manually before i > perform > the UPDATE? > > Thanks a lot! > > -- > David Lozzi > Delphi Technology Solutions > Blog: www.lozzi.net Yeah, i saw them but at $600 per license, i'll figure it out myself.
thanks, Show quote "TheSQLGuru" wrote: > A trigger can do what you need (i.e. putting a changed record into an audit > table prior to or after an update). > > I recommend checking out ApexSQL's Audit. It can set up everything for you > with a mostly point-and-click interface. > > -- > Kevin G. Boles > TheSQLGuru > Indicium Resources, Inc. > > > "David Lozzi" <dlozzi(remove-th***@delphi-ts.com> wrote in message > news:136C1D21-F4AD-4F15-B193-732576A972EA@microsoft.com... > > Howdy, > > > > Forgive me if this is the wrong group. I'm writing a ASP.Net application > > and > > i need to track every change to a table's records. In SQL 2005, is there a > > way to easily keep a record change history? Something with rules or > > triggers > > or something? Or am I stuck comparing every field manually before i > > perform > > the UPDATE? > > > > Thanks a lot! > > > > -- > > David Lozzi > > Delphi Technology Solutions > > Blog: www.lozzi.net > > > $600 is a real bargain for what you get in the package. If you get paid $20
per hour that is only 30 hours before you hit the same amount. No way you can build out a fully functional system like Audit can do for you in that time frame. Note too that the license is just for the client that sets up the auditing. You can audit unlimited servers from that one purchase. See here, http://www.apexsql.com/sql_tools_audit.asp, 4th bullet point from the top. And they have a viewer to report on the audited information that is only $50 per client. -- Show quoteKevin G. Boles TheSQLGuru Indicium Resources, Inc. "David Lozzi" <dlozzi(remove-th***@delphi-ts.com> wrote in message news:F7CA333A-71F4-4B8A-BC90-FD23D60CF3DA@microsoft.com... > Yeah, i saw them but at $600 per license, i'll figure it out myself. > > thanks, > > -- > David Lozzi > Delphi Technology Solutions > Blog: www.lozzi.net > > > "TheSQLGuru" wrote: > >> A trigger can do what you need (i.e. putting a changed record into an >> audit >> table prior to or after an update). >> >> I recommend checking out ApexSQL's Audit. It can set up everything for >> you >> with a mostly point-and-click interface. >> >> -- >> Kevin G. Boles >> TheSQLGuru >> Indicium Resources, Inc. >> >> >> "David Lozzi" <dlozzi(remove-th***@delphi-ts.com> wrote in message >> news:136C1D21-F4AD-4F15-B193-732576A972EA@microsoft.com... >> > Howdy, >> > >> > Forgive me if this is the wrong group. I'm writing a ASP.Net >> > application >> > and >> > i need to track every change to a table's records. In SQL 2005, is >> > there a >> > way to easily keep a record change history? Something with rules or >> > triggers >> > or something? Or am I stuck comparing every field manually before i >> > perform >> > the UPDATE? >> > >> > Thanks a lot! >> > >> > -- >> > David Lozzi >> > Delphi Technology Solutions >> > Blog: www.lozzi.net >> >> >>  |
|||||||||||||||||||||||
Other interesting topics