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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Audit trail of the database

Author  Topic 

lifeql
Starting Member

2 Posts

Posted - 2011-12-14 : 18:33:06
Hi,
At the hotel I work, we use a hotel management software to entry guest informations. Those informations are recorded in the database, MS SQL 2000. The fact is that I have been entrusted with the auditing of datas, however I am not perfect on that database works.
I need to inspect current datas by auditing; for example: Old value, new value. Even every change done by mistake should be seen. I found many trigger tutorials on the net but didn't work or I couldn't handle them correctly in my case. I've seen some softwares like ApexSQL or Idera tools, but they are expensive for our budget.
We have many tables in the database but all I want is to audit particular databases, but I don't know really how to be done. Tutorials suggest general information without applied sample events.
I need a simple (for beginners) statements so that I can adapt it to my case. Thank you so much in advance.



Cogito Ergo Sum(A1:A30)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-14 : 18:44:11
Brett wrote an article a while back that provides the code that would generate the audit tables and triggers for you. Give it a try:

http://weblogs.sqlteam.com/brettk/archive/2006/08/10/11126.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

lifeql
Starting Member

2 Posts

Posted - 2011-12-14 : 18:50:12
Thank you much Tara for immediate reply. I think Brett's trick seems very useful, but I am not sure how to adapt it to my database. I mean, which variants should be changed? What should I do first? I am fully beginner. I wish I could see screenshots or a chart to draw each step.

Cogito Ergo Sum(A1:A30)
Go to Top of Page
   

- Advertisement -