May 4, 2013 at 12:35 am
I have a table for user in my DB(UserID,UserName,FirstName,..).i want to log users that do insert,edit,delete and date of that on all table in my DB.how can i do that????i want clear way to perform this
May 4, 2013 at 3:32 am
Read up on SQLAudit
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2013 at 4:45 am
for example when i want to show list of books to admin.I want to show who insert and edit each record of it and when it happen.it takes query executing high.am i right? if i am right is it better way????? i just want to have edit insert and sometimes deleted for each table
May 4, 2013 at 5:34 am
Huh, didn't understand that...
If you want to audit end user activity, look at the SQLAudit feature. If that doesn't meet your requirements, please explain what it is that you want to do that SQLAudit doesn't.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply