Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

What, when and who? Auditing 101 - Part 2 Expand / Collapse
Author
Message
Posted Tuesday, January 17, 2012 5:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:36 AM
Points: 2,372, Visits: 6,768
Thanks Jason, Thanks Wayne...

-Roy
Post #1237132
Posted Thursday, February 2, 2012 1:56 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:45 AM
Points: 893, Visits: 2,477
Thank you for the articles!

Are you going to cover auditing who reads which data, as well as changes?
Post #1246103
Posted Friday, February 3, 2012 6:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:36 AM
Points: 2,372, Visits: 6,768
Yes, that will be the third part of it. SQL Audit. I have completed 50% of that article. I need couple of more weeks to finish it off and then I will be submitting for publishing.

-Roy
Post #1246465
Posted Tuesday, February 21, 2012 7:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:53 AM
Points: 2,462, Visits: 1,065
Great article, thanks!

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1255264
Posted Friday, March 9, 2012 4:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 10:21 PM
Points: 1, Visits: 17
Bummer!!!

Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions.

But great article nonetheless...
Post #1264256
Posted Friday, December 12, 2014 6:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:36 AM
Points: 2,372, Visits: 6,768
Thanks coetzee.jj for the compliment on the article.

-Roy
Post #1643703
Posted Friday, December 12, 2014 6:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 7:22 AM
Points: 5, Visits: 25
First of all, excellent article.

Now, for a question. I can see this works well for small changes. Would it be equally useful for bulk inserts? Or, we have more of a situation where we have a bulk insert and then small changes over time? I'm guessing this would still be useful, but wanted to know your thoughts.

Thanks,
Paul
Post #1643724
Posted Friday, December 12, 2014 7:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:36 AM
Points: 2,372, Visits: 6,768
It is still useful since the Bulk insert is written to the log. You can always get the changes made by the bulk insert and the subsequent changes. The change table might be large though.

-Roy
Post #1643746
Posted Monday, December 15, 2014 12:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:16 AM
Points: 6, Visits: 33
Is there a trick to getting the parameter values to show up in the sql statement that was run? For this sql:
DECLARE @lastName as varchar(50);
SET @lastName = 'Jones';
SELECT * FROM MyTable where lastname = @lastname;

The audit shows this was run:
SELECT * FROM MyTable where lastname = @lastname;

I want to see:
SELECT * FROM MyTable where lastname = 'Jones';
Post #1644226
Posted Monday, December 15, 2014 1:17 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:36 AM
Points: 2,372, Visits: 6,768
If I am not mistaken, if you use SQL Server 2008 SP2 , parametrized query should show the value when using SQL Audit. But this I have to check. It has been a long time since I wrote this article.


-Roy
Post #1644234
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse