February 4, 2014 at 4:26 am
Hi All,
I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7600: )
how to apply the audit logs on the tables. Please tell me the procedure or suggest me any links.
Thanks in Advance,
Avinash P
February 4, 2014 at 6:03 am
It really depends on what you're attempting to audit. If you want to see data changes, the best bet is to implement change data capture (CDC). If you want to see who is logging in and/or making changes, you'll need to implement either extended events (my preference) or trace events[/url]. Not knowing specifically what you're looking for, that's about all I can say.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 4, 2014 at 5:01 pm
p.avinash689 (2/4/2014)
Hi All,I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7600: )
how to apply the audit logs on the tables. Please tell me the procedure or suggest me any links.
Thanks in Advance,
Avinash P
How wide are the tables in columns?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 4, 2014 at 5:04 pm
Here is a product that covers just about the entire gambit for audit purposes...
http://www.beyondtrust.com/Products/PowerBrokerDatabases/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2014 at 11:56 pm
Jeff Moden (2/4/2014)
p.avinash689 (2/4/2014)
Hi All,I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7600: )
how to apply the audit logs on the tables. Please tell me the procedure or suggest me any links.
Thanks in Advance,
Avinash P
How wide are the tables in columns?
Can't help if I can't get information from you.
If your tables are more than 30 or so columns, use "field level" audit tables. Otherwise, use "row level" auditing.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply