Join | Login | Why Join?

Access to 480 free guest articles, discussions and more, just create your free SSWUG User ID:

Email address:

This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Change Data Capture Feature in SQL Server 2008

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.

Article Abstract:

We have been blogging for quite some time now on the new feature sets of the upcoming release of SQL Server - SQL Server 2008. You can search for SQL Server 2008 on this blog and get to those posts. In this post, we wil cover another new feature called “Change Data Capture”. Using this feature, one can capture the DML activities (insert, update and delete) that take place against the tables. There are two steps that need to happen in order for this to take place: A login that has sysadmin rights first needs to enabled the database for change data capture and then a member of the db_owner database role needs to enable the tables for which the DML activities need to be captured.

Read this article...

Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc. (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004

		*Search* SSWUG: