SQL Server 2000 Table Auditing for HIPAA

[Gregory S Moy]

I'm a VB programmer creating apps to write/edit/delete data to a SQL
Server 2000 database.

For HIPAA requirements, I need to track all changes to all the tables in
our database. I'm looking for the easiest and cheapest solution.

I have no experience writing Sql Server 2000 triggers and stored
procedures.

I have found the following application which might do what I need to do:

Upscene: MSSQL Log Manager
Price $125
http://www.upscene.com

Krell Software : OmniAudit
Price $399
http://www.krell-software.com
Apex SQL Software: Apex SQL Audit
Price $599
http://www.apexsql.com
LogPI: LogPI
Price $825
http://www.logpi.com

Lumigent: Entegra for SQL Server
Price ???
http://www.lumigent.com

Any comments sugestions appreciated.

Gregory S. Moy
Information Processing Consultant
EpiSense Research Program
Department of Ophthalmology & Visual Sciences
University of Wisconsin - Madison

[Erland Sommarskog]

Gregory S Moy (mo*@epi.ophth.wisc.edu) writes:

I'm a VB programmer creating apps to write/edit/delete data to a SQL
Server 2000 database.

For HIPAA requirements, I need to track all changes to all the tables in
our database. I'm looking for the easiest and cheapest solution.

I have no experience writing Sql Server 2000 triggers and stored
procedures.

I have found the following application which might do what I need to do:

I have no experience of the products you list, but I think you are
taking the right step when you look at 3rd party products rather
that trying to roll your own. Too many have already reinvented that
wheel.

There are two basic approaches these tools take. Some add a lots of
trigger to your database, others get the data from the transaction log.
Of those you list, Log PI and Entegra are of the latter school.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp