SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Does Audit Tool works with SQL Express 2008

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Does Audit Tool works with SQL Express 2008
Author Message
Nilesh



Joined: 25 Aug 2011
Posts: 5
Country: India

Post Does Audit Tool works with SQL Express 2008 Reply with quote
Hi,

Does Audit Tool works with SQL Express 2008. Also I am using .NET application to communicate to the SQL Express 2008 database, Is it possible that I can log the application username against each select,update, delete or update query.

Thanks,

Nilesh Patil
Thu Aug 25, 2011 7:38 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6507

Post Reply with quote
Yes, it can handle SQL Express 2008 and log all sorts of operations, including what, who, when, and how
Thu Aug 25, 2011 8:19 am View user's profile Send private message
vastonsmith



Joined: 12 May 2015
Posts: 1
Country: Pakistan

Post Reply with quote
e.g. I am auditing the Accounts table and the user done some operations and then he feels their is some problem with system and he calls the DB Admin for changing the database to previous point. Is it possible with the Audit tool?


Last edited by vastonsmith on Wed Oct 28, 2015 7:23 am; edited 1 time in total
Tue May 12, 2015 9:05 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6507

Post Reply with quote
While data changes cab e restoring from the auditing data, that is not a function of the audit. Database backups are designed just for that. If you use FULL recovery model you can restore to virtually any point in time covered by the backups. You can restore the entire database or restore to a temp one and then just copy over specific tables.
Tue May 12, 2015 11:51 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.