<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Leo Peysakhovich
»
The New Reality of an Audit Trail
13 posts, Page 1 of 2
1
2
»»
The New Reality of an Audit Trail
Rate Topic
Display Mode
Topic Options
Author
Message
Leo Peysakhovich
Leo Peysakhovich
Posted Thursday, June 25, 2009 11:15 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129,
Visits: 205
Comments posted to this topic are about the item
The New Reality of an Audit Trail
Post #742039
Michael Whiteley
Michael Whiteley
Posted Wednesday, July 08, 2009 8:35 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:07 AM
Points: 36,
Visits: 71
If only using SQL 2008 I would use Change Data Capture it does it all for you.
Post #749314
LP-181697
LP-181697
Posted Wednesday, July 08, 2009 9:37 AM
SSC Rookie
Group: General Forum Members
Last Login: Monday, January 30, 2012 5:12 AM
Points: 40,
Visits: 143
Michael Whiteley (7/8/2009)
If only using SQL 2008 I would use Change Data Capture it does it all for you.
Unfortunately, Change data capture is available only on the Enterprise, Developer, and Evaluation editions of SQL Server. E.g. if company has 4-5 production servers with 4 processors each the price between Standard and Enterprise edition is prohibit to use this feature.
Post #749423
alen teplitsky
alen teplitsky
Posted Wednesday, July 08, 2009 1:00 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 2:11 PM
Points: 1,409,
Visits: 4,506
how is this different than the standard audit tables that record changes?
https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #749496
Leo Peysakhovich
Leo Peysakhovich
Posted Wednesday, July 08, 2009 3:58 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129,
Visits: 205
SQL Noob (7/8/2009)
how is this different than the standard audit tables that record changes?
a) it is allowed to gather additional data via XML
b) it is extended to the way that you can record only row changes instead of complete changes (may be for differential load)
c) It shows you not only the audit but how translate audit into something useful, for example to find which products are changed for differential load while you don't need to know exact changes.
At least those points in addition to my previous article where one of the point is the use of ROW_ID instead of complex primary key values.
Post #749693
Leo Peysakhovich
Leo Peysakhovich
Posted Wednesday, July 08, 2009 3:58 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129,
Visits: 205
SQL Noob (7/8/2009)
how is this different than the standard audit tables that record changes?
a) it is allowed to gather additional data via XML
b) it is extended to the way that you can record only row changes instead of complete changes (may be for differential load)
c) It shows you not only the audit but how translate audit into something useful, for example to find which products are changed for differential load while you don't need to know exact changes.
At least those points in addition to my previous article where one of the point is the use of ROW_ID instead of complex primary key values.
Post #749694
Leo Peysakhovich
Leo Peysakhovich
Posted Wednesday, July 08, 2009 3:59 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129,
Visits: 205
SQL Noob (7/8/2009)
how is this different than the standard audit tables that record changes?
a) it is allowed to gather additional data via XML
b) it is extended to the way that you can record only row changes instead of complete changes (may be for differential load)
c) It shows you not only the audit but how translate audit into something useful, for example to find which products are changed for differential load while you don't need to know exact changes.
At least those points in addition to my previous article where one of the point is the use of ROW_ID instead of complex primary key values.
Post #749697
David McKinney
David McKinney
Posted Thursday, July 09, 2009 12:17 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:43 AM
Points: 582,
Visits: 1,601
It's early in the morning (pre-coffee) but where do you construct the xml?
Post #749910
Michael Whiteley
Michael Whiteley
Posted Thursday, July 09, 2009 1:46 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:07 AM
Points: 36,
Visits: 71
Sorry didn't realise they had made that an enterprise only solution...
I just can't understand Microsoft's reasoning behind doing things like this.
Why spend loads of time developing really good features that soo few customers could use (by paying for enterprise) , and then even fewer actually use.
Had this conversation with Microsoft technical people in the past (who don't make these decisions) but there are of the same opinion - why ?
Post #749956
Michael Whiteley
Michael Whiteley
Posted Thursday, July 09, 2009 1:47 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:07 AM
Points: 36,
Visits: 71
Sorry didn't realise they had make the an enterprise only solution...
I just can't understand Microsoft reasoning behind doing things like this.
Why spend loads of time developing really good features that soo few customers could use (by paying for enterprise) , and then even fewer actually use.
Had this conversation with Microsoft technical people in the past (who don't make these decisions) but there are of the same opinion - why ?
Post #749957
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
