SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Audit trail of the database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lifeql
Starting Member

Turkey
2 Posts

Posted - 12/14/2011 :  18:33:06  Show Profile  Reply with Quote
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

USA
36782 Posts

Posted - 12/14/2011 :  18:44:11  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

Turkey
2 Posts

Posted - 12/14/2011 :  18:50:12  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000