Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-03 : 08:42:23
|
| Julio writes "Hi:I need to implement Audit Trail to an SQL 2000 Database that is part of a requirement from one of my customers because of FDA rule they need to keep some type of log of all the updates, inserts and modifications to the database. How can I accomplish this in SQL 2000. I was thinking of creating a trace but I dont know if that is the best way or not.Thanks" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-06-03 : 10:09:06
|
| Or you have to write triggers on the table's you need to keep the Audit trail .Another option can be buying a Audit trail software. i think Lumigent.Com or http://www.lockwoodtech.com/ might help.--------------------------------------------------------------Edited by - Nazim on 06/03/2002 10:14:47 |
 |
|
|
davy_boy2000
Starting Member
28 Posts |
Posted - 2002-06-03 : 10:54:03
|
| There is a software package available that is free that creates the Triggers for you, and supplies a bit of kit for viewing the Audit Trail data. The only constraint is that each table you wish to audit would require a unique identifier, (ie, Timestamp column).The software is called SQLLog. It can be downloaded as Freeware from http://www.rlpsoftware.com.Hope this helps.Julio writes "Hi:I need to implement Audit Trail to an SQL 2000 Database that is part of a requirement from one of my customers because of FDA rule they need to keep some type of log of all the updates, inserts and modifications to the database. How can I accomplish this in SQL 2000. I was thinking of creating a trace but I dont know if that is the best way or not.Thanks"[/quote] |
|
|
|
|
|
|
Audit Trail in SQL 2000